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
SQL> conn andrew/reid
Connected.
SQL> l
1 create table blah (col1 number)
2* segment creation deferred
SQL> /
Table created.
SQL>
SQL> conn / as sysdba
... 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
SQL>
No comments:
Post a Comment