connect as sys or system.
drop user username cascade;
The user and all objects will be removed.
james
--- Mujeeb Chowdhry [EMAIL PROTECTED] wrote:
Hi DBA's,
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
Hi,
Drop user user_name cascade; will drop the user including objects.
Hope this helps,
Muths
At 05:40 AM 5/11/01 -0800, you wrote:
Hi DBA's,
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
Try drop user username cascade;
Mujeeb Chowdhry wrote:
Hi DBA's,
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.
Thanks
Mujeeb Chowdhry
Oracle DBA
--
Please
DORP USER username CASCADE;
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
-Original Message-
From: Mujeeb Chowdhry [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 9:40 AM
To: Multiple recipients of list
PROTECTED]'
Subject: RE: Drop schema and all related objects
DORP USER username CASCADE;
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
-Original Message-
From: Mujeeb Chowdhry [SMTP:[EMAIL
Drop User username Cascade ;
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
Chowdhry
Sent: Friday, May 11, 2001 8:40 AM
To:
Title: RE: Drop schema and all related objects
-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
If there is a lot of objects in the schema you may need to increase
parameter enqueue_resources. If not enougn enqueues this command will give
you an error and user and some objects will not be dropped. If you don't
want to increase this parameter you can repeate this command until user will
be
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: