Re: How to drop database?

From: Juhan Kundla <juhan_at_ensib.ee>
Date: Wed, 07 Apr 1999 18:38:31 +0300
Message-ID: <370B7BF7.E8A5BBCE@ensib.ee>

"Lim, Young-sang" wrote:
>
> Hi everyone!
> I wanna drop database and recreate it.
> But I can't find the way that I can....
> Please help me!

Use server manager (svrmgrxx on NT or svrmgrl on UNIX) connect as internal
shutdown abort (or immidiate or normal or transactional) exit server manager
use oradimxx (I don't know the syntax on UNIX) and delete the database instance and services
delete database files
voila -- no database!!!

Read a previous posting in this newsgroup 'Creating a new database procedure' written by Van Messner about creating a new database. Also the oracle server documentation has anwers to questions like these.

Cheers,
Juhan Received on Wed Apr 07 1999 - 10:38:31 CDT