re: urgent.. error in dropping a user

From: Anneisha Haniff-Mohammed <amohammed_at_neal-and-massy.com>
Date: Wed, 3 Jan 2001 13:53:08 -0400
Message-Id: <10730.125605@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_010F_01C0758C.81047C80 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Doc ID: Note:1066812.6 (from ORACLE METALINK) =20

      Subject:  ORA-604 AND ORA-942 WHEN TRYING TO DROP A USER=20
      Type:  PROBLEM=20
      Status:  PUBLISHED=20
      Content Type:  TEXT/PLAIN=20
      Creation Date:  05-MAR-1999=20
      Last Revision Date:  29-FEB-2000=20
      Language:  USAENG=20

Problem Description:=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 You are trying to drop a user and you receive the following errors:

SVRMGRL> DROP user fred;

ORA-604 "error occurred at recursive SQL level %s" ORA-942 "table or view does not exist"

You verified the user existed by querying dba_users and you checked for = any=20
objects owned by the user in dba_objects and there where zero. You even = created=20
a new user and tried to drop that user and still the errors appeared.

After setting event 10046 (or 942) to see where the statement is = failing, by
issuing from with the session:

alter session set events '942 trace name errorstack forever'; or
alter session set events '10046 trace name context forever, level 4'; Received on Wed Jan 03 2001 - 11:53:08 CST

re: urgent.. error in dropping a user - the note