Error While Running sequence.sql : ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation
(Doc ID 2442987.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 10.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Errors observed while trying to run sequence.sql script
SQL> @sequence.sql
Please enter the name of a schema for the GoldenGate database objects:
GGS
Setting schema name to GGS
CREATE OR REPLACE PROCEDURE "GGS" .seqTrace (
*
ERROR at line 1:
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed
re-validation
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 |
Cause |
Solution |