<pre> SQL> select * from DBA_UNUSED_COL_TABS; OWNER TABLE_NAME COUNT ---------- ------------------------------ --------- PETSTORE PRODUCT 1 EPET1 CUSTOMER_ACCOUNT 2 WEBPETS PRODUCT_INVENTORY 3
PRODUCT_INVENTORY
CREATED_TIME
ALTER TABLE PETSTORE.PRODUCT DROP UNUSED COLUMNS; ALTER TABLE EPET1.CUSTOMER_ACCOUNT DROP UNUSED COLUMNS; ALTER TABLE WEBPETS.PRODUCT_INVENTORY DROP UNUSED COLUMNS;
ALTER TABLE PRODUCT_INVENTORY SET UNUSED COLUMN CREATED_TIME; ALTER TABLE PRODUCT_INVENTORY DROP UNUSED COLUMNS;