Maximum file sizes per database block size

Or: ORA-01144: File size (4224000 blocks) exceeds maximum of 4194303

Depending from the db_block_size you can create datafiles up to one specific size.

If you have a db_block_size=8Kb and try to create a datafile with 33GB in size you will get:

To calculate the max size: db_block_size * 4194303.

Bigfile tablespaces are a feature of Oracle 10g. A bigfile tablespace contains only one datafile (or tempfile) which can be as big as 2^32 (=4GB) blocks.

Bigfile tablespaces are supported only for locally managed tablespaces with automatic segment-space management.
There are two exceptions: locally managed undo and temporary tablespaces can be bigfile tablespaces, even though their segments are manually managed.

System and sysaux tablespace cannot be created as bigfile tablespace.