as the database is not running; simply drop all the datafiles and cleanup your listener.ora and tnsnames.ora file
or call dbca utility and drop the sid with all its assosiated files and entries whereever made
In my opinion, the better option would be to recover the database. You may try this.
a. go up to db mount phase
b. off-line the tablespace for which datafile has been lost
c. then open the database. I may give you the commands step-by-step if u need.
And for dropping database, it is nothing like sybase or MS-SQL where we use to drop a database. (I am from the same background to Oracle, so i can feel it very well). In Oracle, the db is a logical instance. You hv to delete their linked files...It goes like this:
1. All the database files
2. All the COntrol files
3. All the redo log files
4. All the temporary tablespace files
5. And the listener.ora & tnsnames.ora file. (if need or can be left like this).
Hmmm. Seems like uninstalling Oracle and reinstalling Oracle is a bit heavy handed. I just would like to recover from this. In MS-SQL, you would simply offline and drop the database.
To delete the files, do you mean that I go the C:/oracle/ora92/target and delete the entire contents? I tried deleting the database directory (which contains the datafiles) and restarted Oracle but was not happy (actually I simply moved them so I could put them back in this case).
Sorry for the really basic questions. I am in the processes of learning Oracle but am charged with having to administer it while we convert from MS-SQL to Oracle.