Re: How to delete a database?

From: Yasuhiro Ushitaki <ushi_at_po.globe.or.jp>
Date: 1996/11/30
Message-ID: <01bbdec8$2760c760$LocalHost@ns.globe.or.jp>#1/1

Ni hao, Kam-ming Ku.

What is your problem?
Please describe detail of your problem, OS and other environments, also.

On UNIX file system)
0) Check up file names of your data-files,log-files & control-files

   as following. (when database is mounted or opened)

     SELECT name FROM V$DATAFILE;
     SELECT member FROM V$LOGFILE;
     SELECT name FROM V$CONTROLFILE;

1) Shutdown your databases.
2) Delete all your data-files,log-files & control-files (those are

   results of previous SQL) by rm command on UNIX. Though    you can remain some files for reuse.
3) Delete init<SID>.ora file, edit oratab files etc. if you need.

On NT, Win95)
0) 1) Same as UNIX.
2) Do similar to UNIX, but command is del on DOS, or use

   file manager on NT and use explorer on Win95. 3) Delete init<SID>.ora file if you need, and have to drop

   instance-definitions on registory entories with carefully.

-- 
Yasuhiro Ushitaki / Toyo Information Systems Co.,Ltd.

Received on Sat Nov 30 1996 - 00:00:00 CST