OGG-01783 Cannot verify existence of table function that is required to enable schema level supplemental logging

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

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply