-- --Original Message-- --
From: William B Ferguson [mailto:wbfergus@(protected)]
Sent: Tuesday, November 16, 2004 11:06 AM
To: chadi@(protected); thomas.mercadante@(protected)
Cc: oracle-l@(protected)
Subject: RE: Drop user fails with ORA-01418 (See ORA-01418.ora-code.com)
Chadi,
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==$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)]
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:
