DBMS_XDBZ0 Package Body is Invalid and its Compilation Fails due to ORA-02289: Sequence Does Not Exist (Doc ID 1934549.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

XDB is in invalid status.

Package body XDB.DBMS_XDBZ0 is invalid too and cannot compile due to error
PL/SQL: ORA-02289: sequence does not exist

as can be seen selecting from the dba_errors view:

OWNER                NAME                                               TYPE               LINE                                                                 
-------------------- -------------------------------------------------- ------------ ----------                                                                 
TEXT                                                                                                                                                            
---------------------------------------------
XDB                  DBMS_XDBZ0                                         PACKAGE BODY        496
PL/SQL: ORA-02289: sequence does not exist
XDB                  DBMS_XDBZ0                                         PACKAGE BODY        396
PL/SQL: ORA-02289: sequence does not exist

 

 

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