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

You may get this error while creating a tablespace in your environment.

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.

The formula to calculate the max size is db_block_size * 4194303.

If you want to create the greater size of the tablespace.

1. Either your create multiple datafiles.
2. Use bigfile datafile.

   SQL>  create tablespace test extent management local datafile size 30 G uniform size 256k;
   
   Tablespace created.
   
   SQL>
   

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp