You may get this error while creating a tablespace in your environment.
|
1 2 3 4 5 |
SQL> create tablespace test extent management local datafile size 40 G uniform size 256 K; create tablespace test extent management local datafile size 40 G uniform size 256 K * ERROR at line 1: ORA-01144: File size (5242880 blocks) exceeds maximum of 4194303 blocks |
Oracle has some boundaries to set datafile maximum size based on the db_block_size parameter. db_block_size maximum allowed size for datafile 2k 8GB 4K 16GB 8K 32GB 16K 64GB 32K 128GB The formula to calculate the max size is db_block_size * 4194303. If […]