Re: Oracle Dabase Migration

Originally posted by AimHigh
> Hi,
> We have about 70GB Oracle 8.1.7 instance and are managed by a software
> house. We are planning to migrate this db to another new HP machine.
> This consultant who is responsible for this migration wants to clone
> the database and put it on the new machine.
>
> I am also a DBA but dont have much experince of migrating 70GB
> database. Though this method is fast but I prefer export/import method
> to achieve at the same time db tablespace reorganized. Would like hear
> other opinion about this. Thanks in advance,
>
> Norman

Export/Import a 70G database? Say goodbye to Saturday AND Sunday.

IMHO, a shutdown normal/immediate, copy files, bring db back up is your best solution.

--
Posted via http://dbforums.com