oracle drop column - ghdrako/doc_snipets GitHub Wiki

ALTER TABLE JOBS_TEMP SET UNUSED (DUMMY1, DUMMY2)

SELECT * FROM USER_UNUSED_COL_TABS WHERE TABLE_NAME='JOBS_TEMP'

ALTER TABLE JOBS_TEMP DROP UNUSED COLUMNS