Printable View
What?Quote:
Originally posted by nandu
Hi
Can you mention in which directory u see the newly generated dump file?
This may not be a good news... as it was created at
the FATAL time !
Nandu
:(
Error files are generated at fatal time, but not .dmp files. Maybe is not correct if not finished but ... if yes he/she should recover the database with this .dmp without problems.
Cheers
Angel
You can still open the database by offlining the databafile and tablespace. Only the problem will be you will not have all the tables and data of the tablespace.
However, as you mentioned in the previous post, if you have a DMP created last night that would be the best bet
IT WORKED !!!!!!
It seems that the 3rd party software I am using created an export file before dropping the tablespace (the file was created under one of its directories).
Using this export file, I was able to bring back the database to this morning (before my STUPID mistake).
Since this software saved my A**, I should probably mention its name. It is DBArtisan by Embarcadero.
OOPS... I forgot.
Sincere thanks to all who replied or worked at finding a solution. This forum is the best because of people like you.