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 server so that the
above can be accomplisher or am I Waaaaayyyyy off the
mark here.
mohammed
- "Goulet, Dick" <[EMAIL PROTECTED]> wrote:
> 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 I'd not
> loose the original system before you prove that. My
> experience with database file from Solaris to HP-UX
> has been a 100% loss of data. Granted that was on a
> much earlier version of Oracle (6.0.x).
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Saturday, June 07, 2003 7:29 AM
> To: Multiple recipients of list ORACLE-L
> ..
>
>
> Hi all:
>
> We are considering migration of an Oracle eBusiness
> Suite 11.5.8 from
> HP-UX 11.0 to Solaris9.
>
> I'd like to know if anyone has done this and how
> daunting the task is.
>
> Are there any 3rd Party tools which can help out?
>
> Coming to the conventional approaches:
>
> 1. What do you think of Export/Import of a 200 GB
> database?
> 1a. How much time will it take?
> 1b. Any strategies for cutting that down?
>
> 2. How does CTAS over dblink compare to
> Export/Import?
>
> 3. Is there any tool that converts Oracle datafiles
> on HP-UX 11.0 to
> Oracle datafiles on Solaris 9. If so we would just
> need to recreate the
> control files on the target database and we are
> done.
>
> Any suggestions, pointers, words of wisdom are
> greatly appreciated...
>
> Thanks & Regards,
> Sashi
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Sashidhar Kondareddy
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Goulet, Dick
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: mkb
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Mon Jun 09 2003 - 09:53:37 CDT
