SQL> desc lunartest; 名称 是否为空? 类型 ----------------------------------------- -------- ----------------------------
DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(18) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1)
SQL> ALTER TABLE lunartest SET UNUSED (DATA_OBJECT_ID);
表已更改。
SQL> desc lunartest; 名称 是否为空? 类型 ----------------------------------------- -------- ----------------------------
OBJECT_TYPE VARCHAR2(18) CREATED DATE LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1)
SQL> ALTER TABLE lunartest SET UNUSED (OBJECT_TYPE,CREATED);
表已更改。
SQL> desc lunartest; 名称 是否为空? 类型 ----------------------------------------- -------- --------------------------
LAST_DDL_TIME DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1)
SQL>
|