The Oracle SYS user object does not support deferred segments

A table that attempted to establish a deferred segment property in 11.2 encountered a ORA-14223 error:

Sql deferrable

Sql> SELECT * from V$version;

Deferrable keyword in sql

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production

Pl/sql Release 11.2.0.1.0-production

CORE 11.2.0.1.0 Production

TNS for 32-bit windows:version 11.2.0.1.0-production

Nlsrtl Version 11.2.0.1.0-production

Sql> CREATE TABLE t_deter_seg (ID number)

2 SEGMENT creation DEFERRED;

CREATE TABLE t_deter_seg (ID number)

*

Line 1th Error:

ORA-14223: This table does not support deferred creation of segments

Since the deferred segment attribute is a new feature that was introduced in 11.2, it was syntactically incorrect, or there were some limitations to Oracle, and the official document of Oracle was carefully queried, and the results did not see any restrictions on the current issue.

The previous Test delay section does not seem to have encountered problems, and the database version, and the last Test is 11.2.0.1 version, but the operating system is Linux, is not such a simple function and operating system related.

Again check the current environment, finally found the cause of the problem, the current user is SYS:

Sql> Show USER

User is "SYS"

Sql> CREATE TABLE t_deter_seg (ID number)

2 SEGMENT Creation DEFERRED

3 tablespace USERS;

CREATE TABLE t_deter_seg (ID number)

*

Line 1th Error:

ORA-14223: This table does not support deferred creation of segments

It is not unusual for SYS to not support any features, but it is not surprising to find out whether the objects under SYS are not supported or that the objects in the system table space do not support a segment delay.

From the current test, even if the SYS user creates the table to another tablespace, this error can still be caused.

Sql> CONN test/test@test112

is connected.

Sql> CREATE TABLE t_deter_seg (ID number)

2 SEGMENT Creation DEFERRED

3 tablespace SYSTEM;

Table has been created.

It is now possible to determine that the object under the SYS user does not support deferred segment functionality.

Author: 51cto Blog Oracle Little Bastard

Back to the column page: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/