RE: How to move a database from Solaris to Linux

Reinhold,

One thing to try instead of exporting to files and then importing from those files is to run exp/imp through a pipe.

Pick a machine, source or destination - my choice would be destination. Export the remote database to a local pipe, and then import to the local database from that pipe. There are notes and tips on MetalLink about exporting to a pipe, and Rachel and others have published methods to this list.

Cheers,
Mike

> -----Original Message-----
> Sent: Wednesday, September 19, 2001 12:47 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi all,
>
> we have to move a 135 GB Oracle 8.0.6 database from Solaris 7 to Linux.
> We tried a simple restore of the database files from the last offline
> backup (tape) as we did it many times between equal systems.
>
> After creating the new control file on the target system the database
> could not be started, becaue Oracle thinks that the system data file
> isn't really a data file!
>
> This means i have to do an export/import! I assume an export time of
> round about 10 hrs. Is there any easier way?
>
> TIA
>
> Reinhold Wagner
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reinhold Wagner
  INET: rwagner_at_zeunastaerker.de

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).