RE: Deleting database

From: QuijadaReina, Julio C <QuijadJC_at_alfredstate.edu>
Date: Tue, 30 Dec 2003 10:34:41 -0800
Message-ID: <F001.005DB470.20031230103441@fatcity.com>

Branimir,

Correct me if I am wrong, but if I used your approach of dropping schema owner then if I have 25 schemas on my test db, I would have to drop ALL of them? I would think that dropping ALL schemas would equal removing entire database.

Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College

-----Original Message-----
Branimir Petrovic
Sent: Tuesday, December 30, 2003 12:44 PM To: Multiple recipients of list ORACLE-L

Run oradim.exe from command line to see how to delete SID. Deleting Oracle service via oradim _will_ remove corresponding registry entries.

But why bother removing database, wouldn't dropping schema owner with cascade option followed by full import do the trick?

Branimir

>
> Wouldn't I have to worry about any registry info for the test instance
> after physically deleting the OS db files? Would I be able to create
> test using the same instance name?
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  INET: BranimirP_at_cpas.com

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: QuijadaReina, Julio C
  INET: QuijadJC_at_alfredstate.edu

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).

Received on Tue Dec 30 2003 - 12:34:41 CST