Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: export import Speed up

Re: export import Speed up

From: Jamie Kinney <>
Date: Fri, 2 Sep 2005 22:17:37 -0700
Message-ID: <>

The approach entails the following steps:

  1. Create empty tables with appropriate storage clauses in the destination database.
  2. Create database links between databases.
  3. Create unique indexes which correspond to the PK indexes on your source tables.
  4. Create materialized views using the pre-built tables with fairly frequent refresh intervals, but an inital refresh which is a month or two out.
  5. Perform complete refreshes manually on each materialized view.
  6. Perform fast refreshes on each snapshot.
  7. Run the fast refresh jobs to have them start refreshing automatically.
  8. Create any other required indexes.
  9. Create all other packes, views, synonyms, triggers, etc...
  10. At cutover time, shut down the listeners to all traffic except your target server.
  11. Perform a final fast refresh of each table.
  12. Enable constraints novalidate using your existing indexes.
  13. Start up listeners on the new database and open it up to users.

I use DDL wizard (search Google) to parse a dataless export file and generate DDL for any and all objects. It's free and can also be used to change things like storage clauses, schema names, partitioning, etc...

This approach can be used to migrate data between platforms, versions, RAC and non-RAC, ASM and non-ASM.


On 9/1/05, Sunil Bhola <> wrote:
> Hi,
> I am also looking for the same procedure. Please mark a CC to me also.
> Regards,
> Sunil Bhola
> *Dennis Williams <>* wrote:
> Vivek,
> >We need to move a Big Production Database of 600 GB from Oracle 8.1.7 >on
> Solaris 5.6 TO Oracle 9.2 on IBM-AIX using export/import with MIN
> >Downtime.
> Responding to your overall situation, someone recently posted on this
> list a very clever way to move a large database to a new server with minimum
> downtime. As I recall, i t involved moving the data, then using snapshots
> to keep the new copy syncronized until you are ready to cut over.
> Unfortunately I didn't keep a copy of this method. Perhaps someone else on
> the list kept it.
> Dennis Williams
> *QUERIES in Oracle, Feel free to Join:*
> **
> *
> *
> **
> *Regards,*
> *Sunil Bhola*
> *Oracle_Expert, Moderator
> *
> ------------------------------
> Start your day with Yahoo! - make it your home page
> <*>


Received on Sat Sep 03 2005 - 00:19:32 CDT

Original text of this message