fastest method to copy data between databases

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?

David Pelinka - Programmer/Analyst	Direct/Voice: (503)-977-4379
Portland Community College, SY CC 224	Fax: (503)-977-4987
PO Box 19000 Portland, OR. 97280-0990	Internet: dpelinka_at_pcc.edu


--------------------------------------------------------------------