-
Hi, here is the situation.
1. tablespace is dropped yesterday(it is a data tablespace, not temp or rbs or system).
2. not in archivelog mode.
3. no backup exept full export dated 15 august..
4. the datafile is not deleted on the os.
5. The tablespace did not have ddl statement.
Have any idea how to resolve this?
[Edited by steeve123 on 10-03-2002 at 11:15 AM]
-
Unfortunately you are in a world of poo. I don't think you have any other choice but to use your last full export.
Sorry.
MH
-
Unfortunatly, I think that you have lost your datafile ...
But I've heard about an Oracle tool which name is something like DUL to unload data from a datafile and to generate a dump file ...
-
Did the same thing in my early days. Oracle Consulting has a tool that can read the datafiles and spits out the data in a CSV format. For my company, the $2500/day was worth it.
-
3000$ for just five minutes in my case, but that's worth it ...
-
I do hope this was a development box, please tell us it is.
MH
-
Anyone know what is the product that reads a datafile to extract the data and make an .csv file?
-
It's proprietery to Oracle Consulting. They even rm it from your box when they are through.
-
What is the name of the product?
-
As I said : the name of the product is DUL (like Data Unloader).