Put the column mark as "unused" test

zhaozj2021-02-16  82

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>

转载请注明原文地址:https://www.9cbs.com/read-13921.html

New Post(0)