Skip to Main Content

Database Software

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!

Exporting huge tables of size 1000 GB using expdp

Harikanth KonetiAug 17 2017 — edited Aug 23 2017

Hi Folks,

i'm using expdp command to export the tables. The table which i'm exporting having one column data type is clob and table size is around 1000 GB.

i have tried to export this table with parallelism 8 but no luck it's still executing since 9 hours and not sure when it will completes. Even i have tried to create the temporary table(converting clob column with to_lob) with required data but it's not getting created( idea to do this, i can use this temporary table in par file directly).

kindly help me with this.

Many Thanks in advance,

Harikanth.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2017
Added on Aug 17 2017
26 comments
13,878 views