Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I create and delete instance and database?
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
![]() |
![]() |