Re: ERROR: Unused TSTZ columns exist

Posted by big on Jan 09, 2023; 7:48pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ERROR-Unused-TSTZ-columns-exist-tp11389p11424.html

Hi,
really thank you.
Then I ran
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';

I found the table an column name and ran:

"alter table owner.table drop unused columns;"

Every thing is ok now.
Regards.