Copying Data from One Database to Another 1

[jetec]

I have 180 partitions; not configured for transportable tablespaces.

Each partition is huge, (approx 10 million rows) per partition.

I am moving this data to another database (same table name, but different tablespaces names).

What would be the most efficient way of copying the data over? Currently i am using a DB link, but it is taking approx 18mins per partition.

Any ideas?

Thanks!

 

[SantaMufasa]

Jetec,

555,555 rows per minute over a database link is remarkably fast. Count your blessings and run !

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[jetec]

Thanks! I didn't know if there was a quicker method, other than transporting tablespaces.