urgent : recovering the datafile

[srt]

Hi,
I was deleting few files in a test machine for the database 'TEST1', accidentally I deleted files of 'TEST2' in /u08/oradata/TEST2 directory. I do not have a backup for the test database.
When i start the database I am getting an error files are missing. All the files are of one tablespace. How can I drop the tablespace by mounting ?? How can I start the database?

I started mounting and making datafiles offline, but as the pysical file is not present I cannot make offline. Please help urgent

[srt]

HI adding to above... I dont need to have recovery of tablespace but I need to up my database. Once I can startup the database, I can go ahead and create the datafile and the tables related to that

[davey23uk]

startup mount
alter database 'path_to_files' offline drop;
alter database open;
dtop tablespace xxx;

where xxx is the tablespace the datafiles were part of

[srt]

When I am trying to make a datafile offline in mount, I am getting message as datafile is not present. Need to be in archive log mode to make a datafile offline;

[jodie]

You have to use offline DROP

[srt]

Now I am able to drop the datafiles. I will restart the database and drop the tablespace.

Can I create the tablespace and datafiles again with the same name?

Thank you for the help .

[srt]

updated message. I dropped the datafiles and dropping the tablespace using incluing contents option.

Can I create tablespace using same name and datfiles again ?

[davey23uk]

yes make sure you physically deleted the datfiles as wellif you didnt use the 'and datfiles' option