Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving data between Tru64 to Solaris
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