Re: ERROR: Unused TSTZ columns exist

Posted by ErmanArslansOracleBlog on Dec 27, 2022; 12:48pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ERROR-Unused-TSTZ-columns-exist-tp11389p11392.html

You didn't mentioned any details.. you got this error performing what? What stage of the upgrade are you at_

Yes..
It may be the following one also ->
 EXECUTE immediate 'select count (*) from dba_tab_cols c, DBA_UNUSED_COL_TABS o where c.data_type like ''%WITH TIME ZONE'' and c.owner=o.owner and c.table_name = o.table_name and c.HIDDEN_COLUMN = ''YES''' INTO V_CHECKNUM1 ;

What is your database version at the time that you were getting this error?
Did you check the following? ->

**

MOS Note 977512.1 for 11gR2
MOS Note 1509653.1 for 12c .