Hi:
Thanks to everyone who responded to my message on Cross Platform
Migration... I will update the list if we come to any conclusions not
consilient with the findings given on the list..
Thanks Regards,
Sashi
Sashidhar Kondareddy
Project Manager
IT Solutions Inc, a SEI CMM Level 5
Exp/imp of a 200GB database is possible, but I'd think the time required would be the
long pole in the tent. I'd say your looking at at least a 4 day weekend at best and
only if you used direct mode. Someone has hinted that you can simply move the
datafiles from one box to the other. Well
You may want to review an article, Cross Platform Migration of a Large Production
Database, in
the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG).
The author details the procedure he followed to migrtate a 300GB production database
from HP-UX to
IBM AIX.
- Kirti
--- Goulet, Dick
Aah !Hint, hint that some certain RDBMS vendor will offer cross-platform
compatibility of database files soon.
Hemant
At 04:14 AM 07-06-03 -0800, you wrote:
Sashidar:
In THEORY HP datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server and
1. Join the 10i beta program
2. Convert your 9.2 datafiles using the cross-platform transportable
tablespaces feature of a dummy 10i instance.
;-)
Or...
Back when one of our system swas at around 200M, we had a C program
that dumped table data in parallel by rowid ranges, wrote the streams
in
Direct mode doesn't work across platforms [or, at least, I haven't tried
it]. It isn't supported.
SQLLDR, Parallel Export-Import, Parallel Index Build are options -- these
can be done
in parallel. Run at least two rounds of testing to see how you can migrate
the data.
Hemant
At 06:29 AM
Wondering out aloud here. Could you export/imp using
pipes. I remember doing this on a 200gb database
going from 7.3 to 8 on Solaris, granted on the same
server. Took about 4-6 hours if I remember correctly.
Anyway to create a remote pipe on another server to
listen for inputs from another
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/09/2003 07:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over
dblink or ..
You may want to review
Sashidar:
In THEORY HP datafiles and Sun data files are compaible. That is you
can just move the HP data files to the Sun server and recreate the data
files. Both data files are in same endianness and they are cross
platform compatible.
There is no tool to convert a datafile from one OS format
K
I'm looking to move a large database from HP/Compaq/DEC Alpha to Sun. Any
possibility the datafiles might be compatible?
Sashidar
This was discussed quite a bit on this list 5/14, the subject was
quickest method. The consensus seemed to be that:
1. SQL*Loader in direct path mode is the
Why don't you try it? Create a small database on Alpha, rcp it to
HP and see what happens.
On 2003.06.07 09:39 DENNIS WILLIAMS wrote:
K
I'm looking to move a large database from HP/Compaq/DEC Alpha to Sun. Any
possibility the datafiles might be compatible?
Sashidar
This was discussed
11 matches
Mail list logo