The minimum extent size of the tablespace must be 1M when db_securefile is set to always. If the extent size is less than 1M the error ORA-60019 is reported.
1.precreate the tablespaces with a uniform extent size of 1M
SQL> CREATE TABLESPACE TEST DATAFILE '/oracle/oradata/test.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1030K SEGMENT SPACE MANAGEMENT AUTO ;
or
2. Create the tablespace with default local extent management:
SQL> CREATE TABLESPACE TEST DATAFILE '/oracle/oradata/test.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
the above solution for Version 10.2.0.1 to 11.2.0.3
In 12c :
alter system set db_securefile=NEVER scope=both;
For 12c "alter system set db_securefile=NEVER scope=both;" . This worked for me
ReplyDelete