Oracle-L: Re: drop user

From: <Jared.Still_at_radisys.com>
Date: Mon, 04 Aug 2003 15:54:30 -0800
Message-ID: <F001.005C8DF7.20030804155430@fatcity.com>

Personnaly, I like to write a short script to generate the SQL to drop all the users tables with the 'cascade constraints' option.

I then do a 'drop user cascade;'

If there are a lot of tables/indexes, the recursive SQL can take awhile, assuming a fair number of extents per object.

Then again, if you're using LMTs, then the recursive SQL shouldn't be too bad.

Jared

"Ehresmann, David" <David.Ehresmann_at_ps.net> Sent by: ml-errors_at_fatcity.com
08/04/2003 02:59 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        drop user

What is the fastest way to drop a user/schema?

sql>drop user NAME cascade;

disable constraints/keys;
truncate tables;
drop user cascade;

Is there a site out there that describes what happens when a user is dropped? I went to Steve Adam's site and read what he had.

David Ehresmann
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ehresmann, David
INET: David.Ehresmann_at_ps.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------