Goldengate Replicat Abended With OGG-00519 And ORA-00900: Invalid SQL Statement While Executing DDL
(Doc ID 2598771.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Executed below comments followed by DDL on source PDB:
-- drop <table_name> table-- drop <table_name> table as it is no longer requiredDROP TABLE <table_name>;Replicat abended with ORA-00900: invalid SQL statement as mentioned below
2019-09-27 00:47:25 INFO OGG-00482 DDL found, operation [-- drop <table_name> table-- drop <table_name> table as it is no longer required].
2019-09-27 00:47:25 INFO OGG-00489 DDL is of mapped scope, after mapping new operation [-- drop <table_name> table-- drop <table_name> table as it is no longer required
-- drop <table_name> table-- drop <table_name> table-- drop <table_name> table as it is no longer required].
2019-09-27 00:47:25 INFO OGG-10451 DDL operation included [INCLUDE MAPPED], optype [DROP], objtype [TABLE], catalog "<catalog_name>", objowner "<owner_name>", objname "<table_name>".
2019-09-27 00:47:25 INFO OGG-01407 Setting current schema for DDL operation to <owner_name>.
2019-09-27 00:47:25 INFO OGG-00484 Executing DDL operation.
2019-09-27 00:47:25 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [900], ORA-00900: invalid SQL statement], no error handler present.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |