Home » RDBMS Server » Server Utilities » error during dump import: ORA-24170 when drop user
error during dump import: ORA-24170 when drop user [message #346392] Mon, 08 September 2008 07:23 Go to next message
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
Re: error during dump import: ORA-24170 when drop user [message #346406 is a reply to message #346392] Mon, 08 September 2008 08:00 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-24170: %s.%s is created by AQ, cannot be dropped directly
 *Cause:  This object is created by AQ, thus cannot be dropped directly
 *Action: use dbms_aqadm.drop_subscriber to drop the objec

Regards
Michel
Previous Topic: ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON
Next Topic: LogMiner - no records
Goto Forum:
  


Current Time: Wed Dec 07 22:34:28 CST 2016

Total time taken to generate the page: 0.06795 seconds