DDLCTXINFO Invalid objects
(Doc ID 2659158.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 12.3.0.1.4 and laterInformation in this document applies to any platform.
Goal
We have the Golden Gate software on the server but it is currently stopped now. We don't intend to run Golden Gate soon.
However, we have an invalid object in the sys schema that is causing as a result of Golden Gate configuration.
Can you please advise how to resolve this problem.
1* select owner, object_type, object_name from dba_objects where owner = 'SYS' and status <> 'VALID'
XXXX> /
OWNER OBJECT_TYPE OBJECT_NAME
------------------------------ ----------------------- --------------------------------------
SYS PACKAGE BODY DDLCTXINFO
rprm03db> alter package sys.DDLCTXINFO compile body;
Warning: Package Body altered with compilation errors.
XXXX> show errors
Errors for PACKAGE BODY SYS.DDLCTXINFO:
LINE/COL ERROR
-------- -----------------------------------------------------------------
6/9 PL/SQL: Statement ignored
6/9 PLS-00201: identifier 'OGGADMIN.DDLREPLICATION' must be declared
Solution
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
Goal |
Solution |
References |