| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: del instance
Jürg Liechti schrieb:
>
> How can i delete a oracle instance from SQL plus or the svrmgr?
> Thanks in advanced
> George
An instance only consists of processes and shared memory.
Stop your Instance and it is deleted.
Physically there is the instance parameter file and startup jobs to
start your instance on system startup and the internal password file.
Delete them (and under NT remove the Services OracleService<SID> and
OracleStart<SID> with oradim73.exe or the services applet) and you
totally get rid of it.
To delete the database (the data files themselfes) shut down your
instance and delete it as decribed above.
Now you can delete the data files your database consisted of.
This is the way of no return.
If you delete your instance you may set up an new one on your database
for only there the data is saved, but if you delete the database
all data get lost for ever.
Kai Received on Tue Jul 21 1998 - 14:25:24 CDT
 |
 |