database create

[helpme]

Hi,
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

[sreddy]

What O/S and version of database ? whats the method you followed to uninstall.....

[helpme]

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... )

[moff]

Hi,

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.

Cheers

Moff

[sreddy]

Be careful while playing with registry - have a bkup of registry if you are not sure.

http://www.dbasupport.com/forums/sho...?threadid=6389
http://www.dbasupport.com/forums/sho...threadid=11174

[ZOTY]

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?