Search code examples
sqldatabaseoracle-databaseoracle12cdatabase-administration

Oracle Increasing Database Block Size in Oracle 12c

I have this error :

01144. 00000 -  "File size (%s blocks) exceeds maximum of %s blocks"
*Cause:    Specified file size is larger than maximum allowable size value.
*Action:   Specify a smaller size.

when creating a TABLESPACE in 

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

so I want to increasing Database Block Size, but I don't know how, and when I query the DB I got no results:

select distinct bytes/blocks from user_segments;
Solution

  • Probably you're trying to create a really big datafile, try creating the datafile as 100 MB at the beginning and then increase it. Please past the command you're using to create the tablespace.