SQL> DESC LUNARTEST;
Is the name empty? Type
------------------------------------- ---------------------------
Data_Object_id Number
Object_type varcha2 (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);
The table has been changed.
SQL> DESC LUNARTEST;
Is the name empty? Type
------------------------------------- ---------------------------
Object_type varcha2 (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);
The table has been changed.
SQL> DESC LUNARTEST;
Is the name empty? Type
------------------------------------- -------------------------
Last_DDL_TIME DATE
TimeStamp varchar2 (19) status varchar2 (7)
Temporary varchar2 (1)
Generated varchar2 (1)
SECONDARY VARCHAR2 (1)
SQL>