| unable to create queue table [message #450173] |
Mon, 05 April 2010 10:04  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
