Re: importing tablespace file

Hi,

Since I don't have your exact conditions, I will share a similar experience:

I needed to import a table from an old, 'defunct' database into a new database. I have a full "cold" backup of everything.

I proceeded as follows:

I restored the old instance, mounted it (using its own control file), took offline most datafiles except the one where the needed table was, and the system tablespace. (In my case the old database was run in Archivelog mode, so I restored and renamed the 4 archived redo files).
Then I opened the database, and exported the table that I needed. Shut down the old instance.
Brought up again the current instance, and simply imported the table. It did work!!!

Also I recreated that table in several schemas.

Hope this helps a lil

Regards,

Alvaro Fuentes
afuentes_at_goodpremises.com

"larry" <noone_at_nowhere.com> wrote in message news:ZYHr8.252304$Hu6.55068565_at_typhoon.neo.rr.com...
> Greetings
> I have been trying to find a way to import a tablespace file into a
> different (same version - 8i) oracle installation.
>
> I understand the correct way would be to export it from the first
> installation and import it into the second. Unfortunately the first
> installation is quite dead and all I have is the *.dbf tablespace files.
>
> Any suggestions/solutions? TIA and much appreciated.
> Larry
>
>
>
Received on Wed Apr 17 2002 - 04:17:32 CDT