When a DDL is being replicated, the following errors are seen in the event log and opo log.
event_log
Notice: ORA-00942: table or view does not exist. [sp_opst_mt(osp)]
Error: Skipping failed DDL Replication [sp_opst_mt (for o.ORADB-o.ORADB queue QUEUE1)]
opo_ddl_log
9i DDL, User Name = "TEST" Default Schema = "TEST"
DDL_SQL = "DROP TABLE "TEST"."AS" CASCADE CONSTRAINTS" FAILED
Applying DDL - 26
The above error occurs if the DDL is issued at the sql prompt as
SQL> DROP TABLE
TEST.DEMO_SOURCE
Instead of
SQL>DROP TABLE TEST.DEMO_SOURCE
Workaround:
Do not split the DDL statement in multiple lines. Ensure it is in one line.
Example:
SQL>DROP TABLE TEST.DEMO_SOURCE
Resolution:
This issue is resolved in Shareplex 6.1
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center