-
hi folks,
Is there any command to delete the existing database.
I know that it can be done using dbassist; but want to know how to do it manually
regards
sonia
-
Hi,
There is no command as such to delete the Database.
Just delete all the files.
Hope it helps.
Take Care.
-
Hi Sonia,
How to delete existing oracle manually?
Windows platform
------------------------
1. Shutdown the instance and Stop all oracle services that r runnig presently.
from control panel utility.
2. Delete all those services through regedit.
3. Delete the Oracle installed directory .
Unix.
------
1. Shutdown the database.
2. Delete Oracle servoce files ( or file that will created while runing rninstaller from /etc )
3. Remove oracle directory.
Let me know ur views.
Kutty
-
Hi Sonia
If you want to delete the database then delete the following files
shutdown the database
a)Control files
b)data files
c)redolog files
d)Initilisation file
entry from the /var/opt/oratab file or equiv registy entries from NT...
If you want to delete the oracle software .Then follow the steps mentioned by kutty.
regards
Hrishy
-
After stopping Oracle services. You should use ORACLE installer to uninstall it. Then you should delete the files and the entries in the Registry.
Thanks
Kishore Kumar
-
remove all files from
select name from v$datafile
union
select name from v$controlfile
union
select member from v$logfile
/
-
Oracle provides a tool called database configuration assistant (DBCA), this gives you option to delete a database. It will also delete services and all files assocaited with database in Windows environment. In Unix environment the executable is called dbca and you can delete the database.
Sanjay
OCP 8i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|