oracle setting up problem

[william shen]

hi,

i installed oracle 9.2.0.4 on linux 9.0, and i created a database called 'test'. but somehow i deleted all the related control and data files of 'test'. when i tried the "startup" command i got the following error message
"ORA-01079: ORACLE database was not properly created, operation aborted".


then i tried to regenerated 'test' but was told

"ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted"

what should i do? looking forward to reply!

[Jeremy Wilson]

If you deleted all the control files and data files, unless you have a backup you need to recreate the database.