error during dump import: ORA-24170 when drop user [message #346392] |
Mon, 08 September 2008 07:23 |
mfran2002
Messages: 8 Registered: July 2006
|
Junior Member |
|
|
Hello,
i've a problem dropping a user (within a scheduled dump import procedure), this is the error:
ORA-00604: error with recursive SQL
ORA-24170: myuser.QMSGO_R is created by AQ, cannot be dropped directly
ORA-06512: a "SYS.DBMS_RULE_ADM", line 158
ORA-06512: a line 1
i haven't "drop_subscriber" procedure in my dbms_aqadm.sql package...
i have:
PROCEDURE remove_subscriber(queue_name IN VARCHAR2,
subscriber IN SYS.AQ$_AGENT);
but i don't know how to use it...
i tryed this:
remove_subscriber('QMSGO_R', 'MYUSER');
but i got a loto of error...
may you help me?
thanks a lot
mick
|
|
|
|