-
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
I remember when this place was cool.
-
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.
Jeff Hunter
-
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
I remember when this place was cool.
-
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.
Jeff Hunter
-
What is the name of the product?
-
As I said : the name of the product is DUL (like Data Unloader).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|