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

From: MotoX <rat_at_tat.a-tat.com>
Date: Mon, 13 Jul 1998 08:14:06 +0100
Message-ID: <900313996.12961.0.nnrp-07.c2de712e@news.demon.co.uk>

*First*, perform a *full export and a full cold backup* of your existing database.

To delete it, shut it down and remove all the files - look in dba_data_files for a list. Add the initialisation files and redo log files to the list.

To recreate, use the CREATE DATABASE command to get a new instance and empty database. Look in the manuals for details (creating init files, redo logs, catalog, etc.) Then use the full export you made. Alternatively, if you already have the creation scripts from your original db, use them, making any modifications you desire first.

MotoX.

As regards rebuilding
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 Mon Jul 13 1998 - 02:14:06 CDT