Re: ERROR: Unused TSTZ columns exist

Posted by ErmanArslansOracleBlog on Dec 29, 2022; 10:50am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ERROR-Unused-TSTZ-columns-exist-tp11389p11395.html

See known issues section / 6) Known Issues of the Mos Note -> Updating the RDBMS DST version in 12c Release 1 (12.1.0.1 ) and above using DBMS_DST (Doc ID 1509653.1)

You may need to check, and ensure what those columns are. You "may" ( I m not sure yet..) need to drop those columns ..

Because, that MOS note says:

select U.OWNER, U.TABLE_NAME, U.COLUMN_NAME from dba_tab_cols u, DBA_UNUSED_COL_TABS o where u.data_type like '%WITH TIME ZONE' and u.owner=o.owner and u.table_name = o.table_name and u.HIDDEN_COLUMN = 'YES';
If there are (=above select give rows) drop the unused columns using "alter table owner.table drop unused columns;"
If the table is compressed see note 558630.1 Unable To Drop An Unused Column From A Compresed Table Due To ORA-12996


*****But don't take a direct action. you need to first check and be sure.. What are those columns. Are there any data in them What are the tables that those columns belong to? (Table_name.column_name)