Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving data between Tru64 to Solaris

Re: Moving data between Tru64 to Solaris

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 13 Mar 2003 09:03:08 -0800
Message-ID: <b4qdkc01m8e@drn.newsguy.com>


In article <b4pfag$234u$1_at_nnrp01.ops.uunet.co.za>, "QT" says...
>
>Hi All
>
>
>We have an Oracle 817 Database on Tru64. We need to move about a 1/2 a
>terrabyte of data to a Sun Solaris Server.We want to move all the old data
>first which is not being used then move the last 3 months when all the old
>data has been moved . We want to achieve this with the least amount of
>downtime therfore only having Downtime while the last 3 months of data is
>moved. Please advise on the best way to achieve this. Should we use EXP or
>Database Links. or move the datafiles? or any other Ideas?
>
>TIA
>
>QT
>
>

Can't be done by moving the datafiles. They're binary incompatible. Use EXP/IMP, copying the data across a database link, whatever works the quickest. I suspect it's going to be fastest by doing multiple parallel exports and imports.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Mar 13 2003 - 11:03:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US