Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting DB/Instance?
Trace,
I wrote a procedure to do that.
Basically (assume the database is TEST):
1 Stop database.
2 Oradim80 -delete -sid TEST.
3 Remove the TEST entries from tnsnames.ora, sqlnet.ora and listner.ora.
4 Reload (refresh) the listener.
5 Delete all files (datafiles, redo log files etc) of TEST.
Rgrds, CHC
Slash <jonests_at_pdq.net> wrote in message
news:697CE737F47EDAC5.B6D0C9FECC9CF6DE.1CAD27A4A3EB5F9A_at_lp.airnews.net...
> Can some give me some general steps on the removal of SID/Database from a
> server (NT with 8.1.5 Oracle DB) that has multiple databases on it?
>
> --
> Trace R. Jones
> jonests_at_pdq.net
>
> Pay or Accept Money via Credit Card FREE using Paypal.
> Join NOW and get $5 FREE!
>
> https://secure.paypal.com/refer/pal=jonests%40pdq.net
>
>
Received on Wed Jun 28 2000 - 00:00:00 CDT