Re: ERROR: Unused TSTZ columns exist

Posted by big on Dec 28, 2022; 4:47pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ERROR-Unused-TSTZ-columns-exist-tp11389p11393.html

Thank you.

To upgrade original db (12.1.0.2) to 19c

We followed 1585343.1 and did:
sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 28 10:11:53 2022

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> spool upg_tzv_check.log
SQL> @upg_tzv_check.sql
INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 12.1.0.2 .
INFO: Database RDBMS DST version is DSTv18 .
ERROR: Unused TSTZ columns exist. <========
ERROR: ORA-00904 will be seen during DBMS_DST.
ERROR: See the known issues section of
ERROR: note 977512.1 for 11gR2 or note 1509653.1 for 12c .
ERROR: for bug 14732853 .
DECLARE
*
ERROR at line 1:
ORA-20060: Stopping script - see previous message .....
ORA-06512: at line 285
I saw 977512.1: It does not talk about that script: upg_tzv_check.sql
And 1509653.1: it says only: Make sure to use version 1.9 or higher of the upg_tzv_check.sql and upg_tzv_apply.sql scripts.
But none of them show what to do if error : "Unused TSTZ columns exist" is encountered.
Here is the version:
 view upg_tzv_check.sql
Rem
Rem Copyright (c) 2013,2014 Oracle. All rights reserved.
Rem
Rem    NAME
Rem     upg_tzv_check.sql - time zone update check script for 11gR2 (and higher)
Rem  Version 1.9
Rem     published in note 1585343.1 Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database .

Regards.