Drop schema and all related objects

2001-05-11 Thread Mujeeb Chowdhry
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 see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: Drop schema and all related objects

2001-05-11 Thread james ellis
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

Re: Drop schema and all related objects

2001-05-11 Thread Muthaiah
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

Re: Drop schema and all related objects

2001-05-11 Thread Scott Canaan
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

RE: Drop schema and all related objects

2001-05-11 Thread Armstead, Michael A
-L Subject: Drop schema and all related objects 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

RE: Drop schema and all related objects

2001-05-11 Thread Armstead, Michael A
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

RE: Drop schema and all related objects

2001-05-11 Thread Jack C. Applewhite
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:

RE: Drop schema and all related objects

2001-05-11 Thread Jacques Kilchoer
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

RE: Drop schema and all related objects

2001-05-11 Thread Hillman, Alex
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

Re: RE: Drop schema and all related objects

2001-05-11 Thread Mujeeb Chowdhry
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: