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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.