This discussion is archived
4 Replies Latest reply: Sep 17, 2013 6:38 PM by 1000662 RSS

DDL script

AnnamalaiA Journeyer
Currently Being Moderated
Hi ,

I'm trying to setup DDL replication,
for this i have followed the below forum thread detail, Which is provided by Steven,

Re: GoldenGate DDL Replication setup error

while running the ddl_setup script i'm getting the below error message and i unable to use create command in my DB

SQL> create table test (h number(5));
create table test (h number(5))
*
ERROR at line 1:
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed
re-validation


Script error:


Line/pos
----------------------------------------
Error
-----------------------------------------------------------------
260/21
PL/SQL: Statement ignored

260/30
PLS-00905: object GGREP.TRACE_PUT_LINE is invalid

59/9
PL/SQL: SQL Statement ignored


Line/pos
----------------------------------------
Error
-----------------------------------------------------------------
61/23
PL/SQL: ORA-00942: table or view does not exist

66/21
PL/SQL: ORA-02289: sequence does not exist

66/5
PL/SQL: SQL Statement ignored


Line/pos
----------------------------------------
Error
-----------------------------------------------------------------
70/18
PLS-00905: object GGREP.TRACE_PUT_LINE is invalid

70/9
PL/SQL: Statement ignored





DDL TRIGGER INSTALL STATUS
-----------------------------------
OK

DDL TRIGGER RUNNING STATUS
-----------------------------------------------------------------------------

ENABLED
FROM "GGREP" ."GGS_SETUP"
*
ERROR at line 2:
ORA-00942: table or view does not exist


FROM "GGREP" ."GGS_SETUP"
*
ERROR at line 2:
ORA-00942: table or view does not exist


FROM "GGREP" ."GGS_SETUP"
*
ERROR at line 2:
ORA-00942: table or view does not exist



LOCATION OF DDL TRACE FILE
-----------------------------------------------------------------------------

F:\ORACLE\APP\ORACLE\ADMIN\XE\UDUMP/ggs_ddl_trace.log

Analyzing installation status...


STATUS OF DDL REPLICATION
-----------------------------------------------------------------------------

ERRORS detected in installation of DDL Replication software components (3)

Script complete.



Can you please guide me to fix this issue?

Edited by: Atp on May 18, 2011 4:49 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points