OraFAQ Forum: SQL & PL/SQL » Update Time Zone

Home » SQL & PL/SQL » SQL & PL/SQL » Update Time Zone (Oracle Database 12c, 12.1.0.2, Oracle Linux 6.5 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Update Time Zone [message #635839]

Thu, 09 April 2015 16:22

askuncoro
Messages: 4
Registered: April 2015
Location: Global World

Junior Member

I've got a stuck sql line command here about updating Time Zone.
This is what i've done and what the result?
My last statement is:
SQL> 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;SQL> SQL> 2 3 4 5 6 7 8 9 10
11 /

Output 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

SQL> exit

It should be like this:
-- Table list: "APEX_040200"."WWV_FLOW_FEEDBACK_FOLLOWUP"
-- Number of failures: 0
-- Table list: "APEX_040200"."WWV_FLOW_FEEDBACK"
-- Number of failures: 0
-- Table list: "APEX_040200"."WWV_FLOW_WORKSHEET_NOTIFY"
-- Number of failures: 0
-- Table list: "APEX_040200"."WWV_FLOW_DEBUG_MESSAGES2"
-- Number of failures: 0
-- Table list: "APEX_040200"."WWV_FLOW_DEBUG_MESSAGES"
-- Number of failures: 0
-- Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
-- Number of failures: 0
-- Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
-- Number of failures: 0
-- Failures:0
--

There's anyone know what's wrong?

Thanks a lot.

Report message to a moderator

Re: Update Time Zone [message #635840 is a reply to message #635839]

Thu, 09 April 2015 17:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

https://community.oracle.com/thread/3698613

Report message to a moderator

Re: Update Time Zone [message #635841 is a reply to message #635840]

Thu, 09 April 2015 18:03

askuncoro
Messages: 4
Registered: April 2015
Location: Global World

Junior Member

Thanks a lot, sorry for that.

Report message to a moderator

Re: Update Time Zone [message #635939 is a reply to message #635841]

Mon, 13 April 2015 08:25

Bill B
Messages: 1971
Registered: December 2004

Senior Member

Any DBMS_OUTPUT will not occur until the entire block is completed. It will not write during the run. You have to wait until the entire database is done.

Report message to a moderator

Previous Topic:	Query Help
Next Topic:	how to find out AM PM from date column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 20:06:20 CDT 2024