{"id":593,"date":"2013-01-14T16:02:59","date_gmt":"2013-01-14T08:02:59","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=593"},"modified":"2013-01-14T16:02:59","modified_gmt":"2013-01-14T08:02:59","slug":"ogg%e7%9a%84ddl%e8%a7%a6%e5%8f%91%e5%99%a8%e5%af%bc%e8%87%b4drop%e6%93%8d%e4%bd%9c%e5%a4%b1%e8%b4%a5ora-00604ora-04045ora-04064ora-06508ora-06512","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=593","title":{"rendered":"ogg\u7684ddl\u89e6\u53d1\u5668\u5bfc\u81f4drop\u64cd\u4f5c\u5931\u8d25ORA-00604,ORA-04045,ORA-04064,ORA-06508,ORA-06512"},"content":{"rendered":"

--ogg\u5bfc\u81f4drop\u64cd\u4f5c\u5931\u8d25ORA-00604\uff0cORA-04045\uff0cORA-04064\uff0cORA-06508\uff0cORA-06512
\n[oracle@ora10gr2 ~]$ sqlplus \"\/as sysdba\"<\/p>\n

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 13 23:13:54 2013<\/p>\n

Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n

Connected to:
\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
\nWith the Partitioning, OLAP and Data Mining options<\/p>\n

SQL> drop user test cascade;
\ndrop user test cascade
\n*
\nERROR at line 1:
\nORA-00604: error occurred at recursive SQL level 1
\nORA-04045: errors during recompilation\/revalidation of OGG.DDLREPLICATION
\nORA-04064: not executed, invalidated
\nORA-04064: not executed, invalidated package body \"OGG.DDLREPLICATION\"
\nORA-06508: PL\/SQL: could not find program unit being called:
\n\"OGG.DDLREPLICATION\"
\nORA-06512: at line 902
\nORA-04064: not executed, invalidated package body \"OGG.DDLREPLICATION\"
\nORA-06508: PL\/SQL: could not find program unit being called:
\n\"OGG.DDLREPLICATION\"
\nORA-06508: PL\/SQL: could not find program unit being called:
\n\"OGG.DDLREPLICATION\"
\nORA-06512: at line 902
\nORA-04045: errors during recompilation\/revalidation of OGG.DDLREPLICATION
\nORA-04064: not executed, invalidated
\nORA-04064: not executed, invalidated package body \"OGG.DDLREPLICATION\"
\nORA-06508: PL\/SQL: could not find program unit being called:
\n\"OGG.DDLREPLICATION\"
\nORA-06512: at line 902
\nORA-04064: not executed, invalidated package body \"OGG.DDLREPLICATION\"
\nORA-06508: PL\/SQL: could not find program unit being called: \"OGG.D<\/p>\n

\u89e3\u51b3\u8fc7\u7a0b\uff1a
\n[oracle@ora10gr2 11.1]$ ggsci<\/p>\n

Oracle GoldenGate Command Interpreter for Oracle
\nVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
\nLinux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04<\/p>\n

Copyright (C) 1995, 2011, Oracle and\/or its affiliates. All rights reserved.<\/p>\n

GGSCI (ora10gr2) 1> info all<\/p>\n

Program Status Group Lag Time Since Chkpt<\/p>\n

MANAGER STOPPED
\nEXTRACT ABENDED EORA 00:00:00 287:14:37
\nEXTRACT ABENDED PUMP_SO 00:00:00 287:08:09 <\/p>\n

GGSCI (ora10gr2) 2> exit
\n[oracle@ora10gr2 11.1]$ which ggsci
\n\/u01\/app\/ogg\/11.1\/ggsci
\n[oracle@ora10gr2 11.1]$ sqlplus \"\/as sysdba\"<\/p>\n

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 13 23:53:54 2013<\/p>\n

Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n

Connected to:
\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
\nWith the Partitioning, OLAP and Data Mining options<\/p>\n

SQL> @\/u01\/app\/ogg\/11.1\/ddl_disable.sql<\/p>\n

Trigger altered.<\/p>\n

SQL> drop table test;<\/p>\n

Table dropped.<\/p>\n

\u5c0f\u7ed3\uff1a\u8fd9\u4e2a\u95ee\u9898\u662f\u7531\u4e8e\u5728\u8be5\u6570\u636e\u5e93\u4e0a\u90e8\u7f72\u4e86\u652f\u6301ddl\u7684ogg\uff0c\u800c\u6211\u4eec\u5728\u8fdb\u884cdrop\u64cd\u4f5c\u7684\u65f6\u5019ddl\u7684\u89e6\u53d1\u5668\u5c06\u963b\u6b62\u6211\u4eec\u5bf9\u8868\u7684drop\u64cd\u4f5c\uff0c\u6211\u4eec\u4e34\u65f6\u7981\u7528ogg\u7684ddl\u89e6\u53d1\u5668\u540e\u4fbf\u53ef\u89e3\u51b3\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

–ogg\u5bfc\u81f4drop\u64cd\u4f5c\u5931\u8d25ORA-00604\uff0cORA-04045\uff0cORA-04064\uff0cORA-06508\uff0c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32,36],"tags":[43,44,45,46,47,48],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/593"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=593"}],"version-history":[{"count":1,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/593\/revisions"}],"predecessor-version":[{"id":594,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/593\/revisions\/594"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=593"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}