Re: How can I create and delete instance and database?

From: Winnie Liu <poohland_at_hotmail.com>
Date: Sat, 11 Jul 1998 07:48:20 -0700
Message-ID: <6o7tnm$q9i@sjx-ixn10.ix.netcom.com>

I don't know if you can drop the existing database or not. But I do know that Oracle has a command called

CREATE DATABASE <...> REUSE DATAFILE...

I forget about the sytnax, please check the doc for further information. I believe that if those two database name is the same, you will recreate a new database with the same name.

Winnie

ashesh48_at_my-dejanews.com wrote in message <6o5gqc$jb1$1_at_nnrp1.dejanews.com>...
>Hi all, How can I drop the existing database and reuse the
>objects(logfiles,datafiles etc.) of it and create the new database? and How
>can i delete the old Instance and create new one?Thanks for help in
>advance.Ashesh.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Jul 11 1998 - 09:48:20 CDT