Re: RE: Drop schema and all related objects

From: Mujeeb Chowdhry <mujeeb.chowdhry_at_nara.gov>
Date: Fri, 11 May 2001 12:07:35 -0700
Message-ID: <F001.0030161A.20010511121526@fatcity.com>

Thanks to all who replied, it works.

>>> Jacques.Kilchoer_at_quest.com 05/11 1:42 PM >>>

> -----Original Message-----
> From: james ellis [mailto:jellis24_gso_at_yahoo.com]
>
> connect as sys or system.
> drop user "username" cascade;
> The user and all objects will be removed.
>
> --- Mujeeb Chowdhry <mujeeb.chowdhry_at_nara.gov> wrote:
> >
> > How can I drop schema (user and all it's objects). I
> > have one main user in the application and wants to
> > drop user and all related objects. Can anyone help
> > me in this regard.

In My Humble Opinion, connecting as sys or system should be reserved for tasks that cannot be accomplished through another user. Instead, you could connect as any user that has DBA role (or the appropriate privileges) and then issue the drop statement. Also, it can often prove useful later to first do an export of the user and all the objects owned by that user, BEFORE doing the drop user cascade.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mujeeb Chowdhry
  INET: mujeeb.chowdhry_at_nara.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Fri May 11 2001 - 14:07:35 CDT