I need to know how to undo a screw-up. I tried to create a database in sqlplus using the Create Database command. But I made an error when specifing my datafiles. I entered a directory that didn't exist. So now I have a partially created database that I can't mount or can't recreate. How do I delete it's partial existance so that I can recreate the database or how do I create my datafiles now?
I did come across similar problems.....
My OS.....sunsolaris 8
oracle ver 8i.......
When the directory is not existing it will not create the database.
It will fail saying not existing...recreate the dir and rerun the script...it will work.
here I am mentioning the dir in logfiles....and system file dir....and control files..
....otherwise create the dir....in all the mount points and run the script again......it will work...It worked for me.
Hope I have cleared you.
Did you generate these database creation scripts thru dbassist in solaris if you did it is pretty simple just Invoke dbassist again you will have an option to delete the database once you select that in turn it will remove all files
If you have manually created the database creation script they you will have to manually delete all the datafiles.
When you are creating a database I would suggest you use dbassist to generate your database creation scripts because it is much easier once you have generated the scripts you can customze according to ur requirment and then execute from the prompt
I can't use dbassit because we don't have a terminal attached to the sun boxes so I have to telnet in and the display won't work over telnet. I've just updated my DBA Studio version so maybe there will be a way to create a database that way.