My Oracle Support Banner

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 AUGUST 04, 2018

Applies to:

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


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                                                                 
-------------------- -------------------------------------------------- ------------ ----------                                                                 
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




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.