Re: Data Pump error

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 Received on Mon Oct 09 2006 - 08:11:39 CEST