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

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 you want to create the greater size of the tablespace.

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

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:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.