The Oracle SYS user object does not support deferred segments

Source: Internet
Author: User
Tags oracle database


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/


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.