Skip to Main Content

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!

import speed vs export

user5716448Sep 20 2019 — edited Sep 24 2019

Hi,

version 10.2.0.4

If have 2 tables of approx 100gb and indexes of 100gb and export takes n hours how much longer would expect import to take.

My understanding is export just dump of data but import will need to have index creation - assume will be at least double length of time.

Not looking for exact figures just wondered order of magnitude would expect import to take longer.

Thanks

Comments
Post Details
Added on Sep 20 2019
7 comments
1,668 views