Home » Server Options » Streams & AQ » unable to create queue table
unable to create queue table [message #450173] Mon, 05 April 2010 10:04 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
When i try to create the queue table i get the below error.
But this is very strange as none of the object has the name case_activity_q_tab . I have checked this in dba_objects .Please help

SQL> DECLARE
2 BEGIN
3 dbms_output.put_line ('Start - Creating Queue Table - case_activity_q_tab...');
4
5 dbms_aqadm.create_queue_table(
6 queue_table => 'case_activity_q_tab',
7 multiple_consumers => TRUE,
8 sort_list => 'ENQ_TIME',
9 storage_clause => 'TABLESPACE &x_tablespace INITRANS 8 STORAGE
10 (INITIAL &x_initial NEXT &x_next PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 2)',
11 queue_payload_type => 'case_activity_msg_t',
12 compatible => '8.1.7',
13 comment => 'Creating case activity message queue table');
14
15
16 dbms_output.put_line ('Completed - Created Queue Table: case_activity_q_tab.');
17
18 exception
19 when others then
20 catch_error(SQLCODE, 'Error on creation of case_activity_q_tab ' || substr(SQLERRM, 1, 256));
21
22 END;
23 /
old 9: storage_clause => 'TABLESPACE &x_tablespace INITRANS 8 STORAGE
new 9: storage_clause => 'TABLESPACE INTF_DATA INITRANS 8 STORAGE
old 10: (INITIAL &x_initial NEXT &x_next PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 2)',
new 10: (INITIAL 10M NEXT 10M PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 2)',
Start - Creating Queue Table - case_activity_q_tab...
Oracle Server Error = -955
Oracle Server Message = Error on creation of case_activity_q_tab ORA-00955: name
is already used by an existing object

PL/SQL procedure successfully completed.
Re: unable to create queue table [message #450174 is a reply to message #450173] Mon, 05 April 2010 10:05 Go to previous message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
i have checked this with below query . i m very confused.

SQL> select * from dba_objects where object_name ='CASE_ACTIVITY_Q_TAB';

no rows selected
Previous Topic: queue rebuild fails after import
Next Topic: what are aq (merged)
Goto Forum:
  


Current Time: Thu Apr 17 00:03:46 CDT 2014

Total time taken to generate the page: 0.12173 seconds