Re: fastest method to copy data between databases

David Pelinka wrote:
>
> I'm setting up an Oracle database for a data warehouse and would like to
> know what is the fastest way to move (replicate) data. I can't use
> snapshots against a remote view of multiple tables under 7.1.6 due to an
> Oracle bug. I've tried copy (copy from user_at_remote create local_table
> using select * from view) but it's taking 1 hour to move 1,000 - 10,000
> records. Table extents are few. The remote views are complex, but the
> select is fast in the remote database. Copying a single table is fast
> too.
>
> Any experiences you'd like to share?
>

My first thought is to use export and import. You may want to bring the data out of the source database using the two parameters to export CONSTRAINTS=N and INDEXES=N and creating them manually after the data is brought into the target database. The export component of this scenario is even better in 7.3 with the DIRECT option to export.

Michael

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################