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?
"Vladimir M. Zakharychev" <vladimir.zakharychev@gmail.com> schreef in
bericht news:1160462048.965775.249290@i3g2000cwc.googlegro ups.com...
Quote:
Ron Schuster wrote:
Quote:
Vladimir M. Zakharychev wrote:
Quote:
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.
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
Data Pump error
Linear Mode
