Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[ETL] TTS vs expdp/impdp vs ctas (dblink)

872581May 9 2012 — edited May 9 2012

Hi, all.

The database is oracle 10gR2 on a unix machine.

Assuming that the db size is about 1 tera bytes (table : 500 giga, index : 500 giga),

how much faster is TTS (transportable tablespace) over expdp/impdp, and over ctas (dblink) ?

As you know, the speed of etl depends on the hardware capacity. (io capacity, network bandwith, the number of cpu)

I just would like to hear general guide from your experience.

Thanks in advance.

Best Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2012

Added on May 9 2012

#general-database-discussions

1 comment

560 views