DROP A DATABASE - urgent help please

i need to drop a database asap as i cannot mount the oracle instance.

my trouble started when i tried to rename the database using the DBNEWID utility.

nid target=sys/pwd_at_mydb dbname=mydb2

i also reset the dbid at the same time.

because this is just a test db with no data, i didn't take a copy of the control files. altho' i was prompted that the change and validation were successful, it failed to startup.

ORA-01103 database mydb2 in control file is not mydb

not having the original control files BUT having made a copy of the control file to trace, i copied said trace file and edited it to recreate the control file. running:

sql> @e:\mydb_ctl.sql;

gets me SP2-0310 unable to open mydb_ctl.sql

my situation:
* oracle 9.2 sp 5

• win 2000k
• can't mount or open mydb
• can't run my create control file script
• tried dropping thru GUI dbca but no go
• want to DROP MYDB and start all over again - like i said this is just a test.
• alternatively why can't i run my create controlfile script??

any and all answers gratefully received

EDWINAH63 Received on Wed Aug 10 2005 - 01:20:17 CDT