Re: Data Pump error

"Vladimir M. Zakharychev" <vladimir.zakharychev_at_gmail.com> schreef in bericht news: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
>

Ron, Vladimir,

this is NOT a generic XE issue. The posted script works fine on my instance.

Robbert van der Hoorn
OSA it BV
The Netherlands Received on Tue Oct 10 2006 - 10:38:34 CEST