The BIN$... Object is a dropped trigger (it appears to be anyway), that =
is
in the recycle bin, and apparently the drop user statement seems to be
having trouble deleting the user with an associated object in the =
recycle
bin.
To try and get around it, try going the web-enable enterprise manager, =
the
administration page, then Tables (or actaully any object), filter for =
the
owner of the object, the the recycle bin button appears. Or, from the =
sql
prompt, you can do a "purge dba_recyclebin; " (to empty the recycle bin =
for
all users, or connect as the user and issue a "purge recyclebin; ".
I think this will get around the problem you are experiencing.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
Bill Ferguson
U.S. Geological Survey - Minerals Information Team
PO Box 25046, MS-750
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208
~ Think on a grand scale, start to implement on a small scale ~
-- --Original Message-- --
From: oracle-l-bounce@(protected) =
[mailto:oracle-l-bounce@(protected)]
On Behalf Of chadi@(protected)
Sent: Tuesday, November 16, 2004 8:32 AM
To: 'Mercadante, Thomas F '
Cc: oracle-l@(protected)
Subject: RE: Drop user fails with ORA-01418 (See ORA-01418.ora-code.com)
Actually, this is my problem. I couldn 't drop some objects in the user, =
so
i decided to rebuild the user and still stuck with this:
the trace is shwoning that some trigger is causing the ora600:
ksedmp: internal or fatal error
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [15239], [], [], [], [], [],
[], [] Current SQL statement for this session: drop trigger
"CHADI ". "BIN$5/+ZaDjf/yjgMIEKQwE88g=3D=3D$0 "
Chadi.
-- --Original Message-- --
From: Mercadante, Thomas F [mailto:thomas.mercadante@(protected)]
Sent: Tuesday, November 16, 2004 10:24 AM
To: 'chadi@(protected) '; oracle-l@(protected)
Subject: RE: Drop user fails with ORA-01418 (See ORA-01418.ora-code.com)
Chadi,
Did the user get dropped?
If not, can you go through and drop the users objects manually? And =
then
drop the user? It is obviously an Oracle problem. But if you can find =
a
workaround, then you can chalk it up to experience.
Personally, I do not drop a user that has a bunch of objects. I prefer =
to
drop all the objects first and then the user just for this reason.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-- --Original Message-- --
From: Chadi Kassan [mailto:chadi@(protected)]=20
Sent: Tuesday, November 16, 2004 10:01 AM
To: oracle-l@(protected)
Subject: Drop user fails with ORA-01418 (See ORA-01418.ora-code.com)
Hi everyone,
I 'm pretty sure, many had run into this problem before and can provide
some help. When I try to drop one of my user, I get the following:
