Thanks to all who replied, it works.
>>> [EMAIL PROTECTED] 05/11 1:42 PM >>>
> -----Original Message-----
> From: james ellis [mailto:[EMAIL PROTECTED]]
>
> connect as sys or system.
> drop user "username" cascade;
> The user and all objects will be removed.
>
> --- Mujeeb Chowdhry <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
