Re: Dropping User bug V7.1.3

>
>I would like to respond to a previous post about a bug in dropping users
>in Oracle 7.1.3 (at least on UNIX). Apparently, when you issue the "DROP
>USER username" command, it can take up to 20 hours, running the
>serial# of the session serially upwards.
>After talking with Oracle support (and experimenting on my own), it
>appears that this problem occurs when the user has objects, especially
>packages.
>
>The best method of dropping a user then is to drop the tables, sequences,
>synonyms, packages, etc. from the user. Then, dropping the user (without
>the CASCADE) clause, will work normally.
>
>FYI, you can write a script to drop the user's objects. An example for
>tables follows:
>-------------------------------------------------------------
>SET PAUSE OFF
>SET HEAD OFF
>SPOOL X.SQL
>SELECT 'DROP TABLE username.'||TABLE_NAME||';'
> FROM DBA_TABLES
> WHERE OWNER = 'username';
>SPOOL OFF
>SET ECHO ON
>_at_X
>-------------------------------------------------------------
>Note: be sure to replace "username" with the proper username above.
>
>Hope this helps.
>
>-Ari

Your script is good but on my SCO-Unix version of Oracle DROP USER CASCADE works Ok (it was be tested on 7.1.3 and 7.1.4).

Alexander Alesinsky Received on Fri Aug 25 1995 - 00:00:00 CEST