Re: cannot drop roles or users

Re: cannot drop roles or users

 

  


update OS patches



BR//
Majid Yousuf






"Goodwin Margot "
<oracledba-ezmlmshield-x59842777.[Email address protected]
29/09/2006 01:25 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
cannot drop roles or users






I am getting this error:

VBO-5530:User cannot be dropped. ORA-01001:invalid cursor
ORA-00600: internal error code,
arguments:[qmxiUnpPacked2],[121],0,0,0,0,0,0

I was running a script provided by a software vendor who shall remain
nameless that I have run before on another development server (windows
2003, Oracle 9.2.0.7). The script creates the user and the user's
objects - tables, views, synonyms, roles etc.

The sql log says that there were no creation errors, but I have no
schema objects and cannot drop the user or the roles. What a mess!
Please help!

Margot Goodwin
Associate Analyst, IT Systems

Emisphere Technologies, Inc.
765 Old Saw Mill River Road
Tarrytown, NY 10591-6715
(914) 593-8336
[Email address protected]



Confidentiality Notice:

This message and its attachments may contain privileged and/or
confidential information and is intended only for the addressee. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, retention, distribution or use of information
contained in this message is strictly prohibited. If you received this
message in error, please notify the sender immediately by return email and
permanently delete all copies of this message and any attachments.


Thank you.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information. If you are
not the intended recipient, please contact the sender by reply e-mail and destroy
all copies and the original message. Any unauthorized review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken
in reliance on this e-mail is strictly prohibited and may be unlawful.The recipient
acknowledges that Bharti Airtel Limited or its subsidiaries and associated companies(collectively "Bharti Airtel Limited"), are unable to exercise control or ensure or guarantee the integrity of/overthe contents
of the information contained in e-mail transmissions and further acknowledges that any views
expressed in this message are those of the individual sender and no binding nature of the
message shall be implied or assumed unless the sender does so expressly with due authority of Bharti Airtel Limited.Before opening any attachments please check them for viruses and defects.

Oracle LazyDBA home page