I had a local database which i un-installed and then i reinstalled..
But the old database still xists.....
how do i drop the old database
and create a new 1
Can any1 pls give me step by step routine for this....
thanx in advance
What O/S and version of database ? whats the method you followed to uninstall.....
Its a NT machine.....
ive removed the old datbase..
Now how do i cerate a new 1?
(Even if the question sound a bit stupid,pls answer cause me a novice programmer aspiring to be a DBA... )
Run the database assistant in the $ORACLE_HOME/bin directory. It's called dbassist in Unix - I presume it's the same on NT.
Alternativley run the 'create database' command from within Server Manager on the command line.
what do you mean on "the database still exists" ? Are there all datafiles and controlfiles being made removed.
Anyway, have you made a shutdown on the instance? Are backgound processes still alive?
Click Here to Expand Forum to Full Width