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: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
