Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error on Upgrade Time Zone on Database 12c

2619151Apr 9 2015 — edited Apr 9 2015

Hello,

I've got stuck here about upgrading timezone on database 12c.

Right now, i've upgrading the timezone using this doc id.

Updating the RDBMS DST version in 12c Release 1 (12.1.0.1 and up) using DBMS_DST (Doc ID 1509653.1)

On step :


set serveroutput on

VAR numfail number

BEGIN

DBMS_DST.UPGRADE_DATABASE(:numfail,

parallel => TRUE,

log_errors => TRUE,

log_errors_table => 'SYS.DST$ERROR_TABLE',

log_triggers_table => 'SYS.DST$TRIGGER_TABLE',

error_on_overlap_time => FALSE,

error_on_nonexisting_time => FALSE);

DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);

END;

/

output on my Server is :

Table list: "APPLSYS"."FND_STATTAB"

BEGIN

*

ERROR at line 1:

ORA-00904: "T"."SYS_C00025_15040721:37:44$": invalid identifier

ORA-06512: at "SYS.DBMS_DST", line 1107

ORA-06512: at line 2

What was happen?

thanks a lot.

Regards,

GatotRu

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2015
Added on Apr 9 2015
7 comments
2,914 views