Thursday, October 18, 2012

ORA-14223

This was tested on Oracle 11.2.0.2.7. You can create a table with deferred segment creation as follows: 

SQL> conn andrew/reid
Connected.
SQL> l
  1  create table blah (col1 number)
  2* segment creation deferred
SQL> /
 
Table created.
 
SQL>

... but some users, e.g. SYS, are not allowed to do this: 

SQL> conn / as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> l
  1  create table blah (col1 number)
  2* segment creation deferred
SQL> /
create table blah (col1 number)
*
ERROR at line 1:
ORA-14223: Deferred segment creation is not supported
for this table
 

No comments: