My Oracle Support Banner

Goldengate Replicat Abended With OGG-00519 And ORA-00900: Invalid SQL Statement While Executing DDL (Doc ID 2598771.1)

Last updated on OCTOBER 18, 2019

Applies to:

Oracle GoldenGate - Version 19.1.0.0.0 and later
Information 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 required
DROP 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.