Friday 21 August 2015

ORA-29339: tablespace block size 16384 does not match configured block sizes

When running a script in OTM got failed with below error .


Issue
++++++
BEGIN create_tablespace.create_all_ts('/u01/app/otmuser/oradata/OTM/', '200M','2G'); END;

*
ERROR at line 1:
ORA-29339: tablespace block size 16384 does not match configured block sizes
ORA-06512: at "SYS.CREATE_TABLESPACE", line 133
ORA-06512: at "SYS.CREATE_TABLESPACE", line 530
ORA-06512: at "SYS.CREATE_TABLESPACE", line 219
ORA-06512: at "SYS.CREATE_TABLESPACE", line 158
ORA-06512: at line 1

Cause
+++++
If you attempt to create a tablespace with a non-standard blocksize, say 16K, you get an exception like this:In order to create the tablespace, you'll need first to allocate a specific buffer for these blocks and this can be done online:

Solution
++++++++
SQL> ALTER SYSTEM SET DB_16K_CACHE_SIZE=16M SCOPE=BOTH;

System altered.

SQL>

run the script .


No comments:

Post a Comment