Re: Data Pump error

From: Ron Schuster <ronschuster123_at_yahoo.com>
Date: Mon, 09 Oct 2006 14:52:07 -0400
Message-ID: <12il6gu60hnhid7_at_corp.supernews.com>

[Quoted] 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%'
;

[Quoted] OWNER                          TABLE_NAME
------------------------------ ------------------------------
SYSTEM                         AQ$_QUEUE_TABLES
SYSTEM                         AQ$_QUEUES
SYS                            AQ$_QUEUE_TABLE_AFFINITIES
SYS                            AQ$_QUEUE_STATISTICS

SQL> Received on Mon Oct 09 2006 - 20:52:07 CEST