ERROR OGG-01783 Cannot verify existence of table function that is required to enable schema level supplemental logging
Error:
Getting the following error during Add schematrandata command:
GGSCI> add schematrandata
OGG-01783 Cannot verify existence of table function that is required to enable schema level supplemental logging
Cause:
Presence of invalid objects
Solution:
1. Check the status of object which are invalid in database.
SELECT owner, object_name, status, object_type FROM DBA_OBJECTS where status = 'INVALID';
2. Tried to compile them with utlrp.sql script present in RDBMS folder of Oracle Home
Location: ORACLE_HOME\rdbms\admin\utlrp.sql
@?\rdbms\admin\utlprp.sql