OraFAQ Forum: Server Utilities » error during dump import: ORA-24170 when drop user

Home » RDBMS Server » Server Utilities » error during dump import: ORA-24170 when drop user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: error during dump import: ORA-24170 when drop user [message #346406 is a reply to message #346392]

Mon, 08 September 2008 08:00

Michel Cadot
Messages: 68648
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 18:21:10 CDT 2024