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

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 […]

Read More