Login  Register

ERROR: Unused TSTZ columns exist

Posted by big on Dec 27, 2022; 9:27am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ERROR-Unused-TSTZ-columns-exist-tp11389.html

Hi,
Installing E-Business R12.2.9

When runnig upg_tzv_check.sql.
I have :

ERROR: Unused TSTZ columns exist


In upg_tzv_check.sql it checks for:

select count (*) from dba_tab_cols c, DBA_UNUSED_COL_TABS o where c.data_type like ''%WITH TIME ZONE'.

What solution do you suggest?
Regards.