Fwd: Database upgrade for big database

From: Steve Harville <steve.harville_at_gmail.com>
Date: Fri, 24 Aug 2012 15:03:07 -0400
Message-ID: <CAGd4=DTY5oTtH9B0hddaMo-1WiGi_djHWzOTQCknitdad+R8+Q_at_mail.gmail.com>

Hi Sanjay, I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel options. The data was imported in about two hours and the indexes took another 7 hours. There was no downtime but we kept the users off the system while this was happening.
Steve Harville


Can someone share his experience in upgrading some big databases like 1Tb
> or so from 10g to 11g and also moving them to new server.

Received on Fri Aug 24 2012 - 14:03:07 CDT

Original text of this message