Reinhold,
I am afraid export import is the only way to migrate the
database from one Operating system to another operating Systems
and oracle data files are not compatible across various
operating systems (with a single exception of Solaris-HPUX)
If you are using Solaris (or HP UX) you can copy the data files
to HP UX( to Solaris if you use HP) and recreate the control
files and you can open the database. I don't know Oracle
Support's stand on this type of migration.
I am developing a tool which will do the migration
from one operating system to another operating system
(Basically it will read block by block and write to
the another operating system file format) and you can
copy (or binary FTP) the file to the target operating
system and recreate the control file and you are set to go
I don't have much experience in DB/2 and I can not
comment about that compatibility issues in DB/2. But
different operating systems uses different file formats
to store the data and oracle also has to follow the
rules to read/write the data files in those operating
systems.
If you have after interconnect (read GB n/w) you can
copy the tables over dblink and this will be much faster
than conventional export and Import. I don't have the
exact figures .. but this will reduce the downtime if you
have faster interconnect.
Why don't you file an enhancement request with oracle
seeking this ? :-)
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-----Original Message-----
Wagner
Sent: Thursday, September 20, 2001 1:00 AM
To: Multiple recipients of list ORACLE-L
Christopher,
i don't consider Solaris and Linux as different OS. IMO they are at
least similar if not equal from the DBMS point of view. I don't see any
reason why the data files should be different on Solaris, Linux or any
other UNIX OS.
I know from DB/2 that the data files are binary compatible on all OS and
I can't believe that's not true for Oracle.
regards
Reinhold
Christopher Spence wrote:
> You cannot move data files from one OS to a different one due to the
> differences in how they write to files.
>
> Import and Export is generally the accepted way to do this.
>
> "Do not criticize someone until you walked a mile in their shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax: (707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
>
> -----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]
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).
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
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).
