Re: Drop user <username> Cascade

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Tue, 24 Sep 2002 14:08:16 GMT
Message-ID: <3D9071D0.F1BB8167@peasland.com>

Start SQL Trace in your session:

ALTER SESSION SET sql_trace=TRUE;

Then drop the user:

DROP USER <username> CASCADE;

You will receive the ORA-604 error as to be expected.

Now proceed to the trace file generated for you session. It will be in USER_DUMP_DEST. Examine the trace file, and you will be able to find the exact SQL statement that caused this problem. Since it is an index that is missing, you can probably recreate the index and then proceed.

HTH,
Brian

Fredrick Jeyakumar Roberts wrote:
>
> ERROR at line 1:
>
> ORA-00604: error occurred at recursive SQL level 1
>
> ORA-01418: specified index does not exist
>
> Any ideas .. Thanks in advance.. Fred
Received on Tue Sep 24 2002 - 09:08:16 CDT