Re: Data Pump error

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 9 Oct 2006 23:34:09 -0700
Message-ID: <1160462048.965775.249290_at_i3g2000cwc.googlegroups.com>

Ron Schuster wrote:
> Vladimir M. Zakharychev wrote:
> > Ron Schuster wrote:
> >> SQL> show errors package body sys.dbms_aqadm_sys
> >> Errors for PACKAGE BODY SYS.DBMS_AQADM_SYS:
> >>
> >> LINE/COL ERROR
> >> -------- -----------------------------------------------------------------
> >> 1415/20 PL/SQL: Item ignored
> >> 1415/27 PLS-00302: component 'AQ$_QUEUES' must be declared
> >> 1418/5 PL/SQL: SQL Statement ignored
> >> 1418/27 PLS-00320: the declaration of the type of this expression is
> >> incomplete or malformed
> >>
> >> 1418/33 PL/SQL: ORA-00904: : invalid identifier
> >> 1426/5 PL/SQL: SQL Statement ignored
> >> 1428/50 PL/SQL: ORA-00904: "OBJNO": invalid identifier
> >> 1428/50 PLS-00320: the declaration of the type of this expression is
> >> incomplete or malformed
> >>
> >> LINE/COL ERROR
> >> -------- -----------------------------------------------------------------
> >>
> >> 1436/6 PL/SQL: SQL Statement ignored
> >> 1438/15 PL/SQL: ORA-00904: "OBJNO": invalid identifier
> >> 1438/15 PLS-00320: the declaration of the type of this expression is
> >> incomplete or malformed
> >>
> >> 1448/9 PL/SQL: Statement ignored
> >> 1449/13 PLS-00320: the declaration of the type of this expression is
> >> incomplete or malformed
> >>
> >> 1881/21 PL/SQL: Item ignored
> >>
> >> LINE/COL ERROR
> >> -------- -----------------------------------------------------------------
> >> 1881/28 PLS-00302: component 'AQ$_QUEUE_TABLES' must be declared
> >> 1882/21 PL/SQL: Item ignored
> >> 1882/28 PLS-00302: component 'AQ$_QUEUES' must be declared
> >> 1883/21 PL/SQL: Item ignored
> >> 1883/28 PLS-00302: component 'AQ$_QUEUES' must be declared
> >> 1888/28 PLS-00302: component 'AQ$_QUEUES' must be declared
> >> SQL>
> >
> > Next step is to figure out why catqueue.sql didn't create these tables.
> > They should've been created with SYSTEM being the owner. You can verify
> > their existence, for example, with this SQL:
> >
> > select owner, table_name from dba_tables where table_name like
> > 'AQ$\_QUEUE%';
> >
> > Check if they do exist and the owner is correct. If they are not there,
> > try creating them manually using the corresponding CREATE TABLE
> > commands in the rdbms/admin/catqueue.sql script (the path is relative
> > to your Oracle home directory,) and see if there are any errors
> > preventing them from being created. If they are owned by wrong user,
> > you will need to drop them and re-run catqueue.sql script again, logged
> > in as SYSDBA.
> >
> > Regards,
> > Vladimir M. Zakharychev
> > N-Networks, makers of Dynamic PSP(tm)
> > http://www.dynamicpsp.com
> >
> They are there and SYSTEM is the owner. Next idea?

>
>

> SQL> select owner, table_name from dba_tables where table_name like
> 'AQ$_QUEUE%'
> ;

>


> OWNER                          TABLE_NAME


> ------------------------------ ------------------------------

> SYSTEM                         AQ$_QUEUE_TABLES

> SYSTEM                         AQ$_QUEUES

> SYS                            AQ$_QUEUE_TABLE_AFFINITIES

> SYS                            AQ$_QUEUE_STATISTICS

>

> SQL>
Hmm... Then verify that DBMS_AQADM_SYS package and its body have the right owner (SYS). If it is so, then I'm at loss. Don't have an XE instance handy so I can't check myself if this is a generic XE issue or just something with your installation. Did you try official XE support forum?

Regards,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Tue Oct 10 2006 - 08:34:09 CEST