Export/Import File Copy + Upgrade Script DB link + Direct Load Insert (Entire) DB link + Direct Load Insert (Delta) DataGuard + Upgrade Script DataGuard + Transportable Tablespace
Reduced Business Downtime
1. Create standby server for 10g on new server 2. Install Oracle 11g with all required Paches 3. stop the primary and activate the Standby server 4. Upgrade the Standby server with 11g Software already installed
This process will save in installing Oracle 11g and performing any datapump export/import and save big downtime to few hours
only while upgrading the environment.
datapump import (impdp) using NETWORK_LINK option