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!

Improving export/import of table

TJ_TayJan 2 2019 — edited Jan 9 2019

Hi all

I am using,

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for Solaris: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

I need to export a huge set of data from a table. However, the export is very slow. It took 3hours to get 90GB dmp file

I wanted to know how can I improve the export and import of the table.

Can I increase the buffer size and recordlength to improve the performance?

How can I determine the buffer size?

Below is the data type of my table,

Header 1Type
NUMBER(19)
VARCHAR2(100 CHAR)
VARCHAR2(1 CHAR)
VARCHAR2(10 CHAR) 
VARCHAR2(30 CHAR)
CLOB
DATE
VARCHAR2(1 CHAR)
DATE
DATE
VARCHAR2(300 CHAR)
VARCHAR2(32 CHAR)
VARCHAR2(1000 CHAR)
NUMBER(10)
Comments
Post Details
Added on Jan 2 2019
16 comments
751 views