-
HELLO
I HAVE DESIGNED A MULTI-MASTER REPLICATION WITH 3 DATABASES.AS YOU KNOW BEFORE UPDATING THE TABLES
IN MASTER DEFINITION SITE I MUST CHANGE THE MODE OF
REPLICATION TO "NORMAL".I CHANGE IT AND THEN I TRY TO UPDATE ONE OF MY TABLES IN MASTER GROUP BUT WHEN I WANT TO INSERT A ROW ,I RECIEVE THIS ERROR :
ORA-25205 : THE QUEUE SYSTEM.DEF$_AQCALL DOES NOT EXIST.
WOULD YOU PLEASE TELL ME WHAT HAPPEND?
I DONT EXACTLY KNOW WHAT IS IT? JUST I KNOW IT IS A QUEUE TABLE!!!
THANK YOU SO MUCH.
PARVIN
-
You need to create the queue first before specifying it for enqueue. The queue is created by the script catdefrt.sql.
The queue table needs to be dropped before running catdefrt.sql.
First alter session set events '10851 trace name context forever, level 2';
drop table system.def$_aqcall;
drop table system.def$_aqerror;
Rerun catdefrt.sql to recreate the queues and the queue tables.
-
AN ERROR MESSAGE AND SO MUCH THANKS
DEAR JULIAN,
I DID WHAT YOU SAID,BUT I RECIEVED THIS ERROR:
ORA-24005 : MUST USE DBMS_AQADM.DROP_QUEUE_TABLE
TO DROP QUEUE TABLE;
I DROPED QUEUE TABLES VIA DBMS_AQADM.DROP_QUEUE_TABLE AND THEN EXECUTED CATDEFRT.SQL ,MY PROBLEM IS SOLVED AND NOW I AM
VERY GRATEFUL .
WITH BEST REGARDS
PARVIN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|