Hi there,

Currently, our production database produces 1G export dump. It contains some large table which contains 1 million rows.

We need to import the Production Data into development machine for full testing everyday.

However, I think that the import speed is quite slow.

Our development Platform is SUN E420R with 2G RAM.

Import take nearly 2.5 - 3 hours to completely load all data into DB. It is very time-consuming.

Currently, I already used INDEX=N to prevent user index update during import.

BUFFERS is also increased in IMP parameter.

Any other way to increase the speed of import?