Re: How to delete a database?
From: Yasuhiro Ushitaki <ushi_at_po.globe.or.jp>
Date: 1996/11/30
Message-ID: <01bbdec8$2760c760$LocalHost_at_ns.globe.or.jp>#1/1
1) Shutdown your databases.
2) Delete all your data-files,log-files & control-files (those are
Date: 1996/11/30
Message-ID: <01bbdec8$2760c760$LocalHost_at_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 CET