ORA-06564 'object <name> does not exist' and ORA-1403 'no data found' Errors When Running DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION (Doc ID 745688.1)

Last updated on SEPTEMBER 08, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

While removing Streams from a 10.2 database via the procedure DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION, the following errors are received:


SQL> execute DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
BEGIN DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION(); END;

*
ERROR at line 1:
ORA-06564: object "<OWNER>"."BIN$WhLnzRoPa8DgRAAUTwNLbA==$0" does not exist
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 82
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 115
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 490
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 395
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1877
ORA-06512: at line 1



where <OWNER> is a schema in the database.  The object name shown in the ORA-06564 error does not need to have exactly the same name as the name shown in the above error example.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms