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.