Re: recover from datafiles

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 28 Feb 2003 19:37:02 +0100
Message-ID: <otav5vk30s9oabeup93mnum2ppkols34vh@4ax.com>

On Fri, 28 Feb 2003 18:44:35 +0100, "goldenjoe" <goldenjoe_at_libero.it> wrote:

>I know that this question is usual, but I need a clarification about the
>matter.
>I have got 2 datafiles form a database and I want to know if is possible to
>import or link them in a new database: I'm almost sure that they're not
>corrupted.
>
>thanks
>
>

It is NOT possible.
Think of it: are the datafile headers likely in sync with the rest of your database? NO
Does Oracle know how to retrieve dictionary information from the datafiles? No, unless you are willing to pay for an Oracle rep bringing in DUL and even in that case you won't get meaningful column names.
If you would have them as export: YES, or in TRANSPORTABLE TABLESPACE format YES. All other scenarios: Big NO NOs

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 28 2003 - 12:37:02 CST