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 1 | Type |
|---|
| 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) |