Import

[soniaarora]

Hi,

1.What has to be done to make import run faster?
2. How many rows get commited when we specify commit=y?

Sonia

[Sameer]

1. BUFFER = n (number)

Parameter that defines the number of rows inserted into a database at one time.

2. COMMIT=Y

Specifies whether IMPORT should commit after each time a buffer’s worth of data is written to the database

Sameer

[SANJAY_G]

If you have any index on the table drop the index, import the data and recreate the index.
Be careful if that index is supporting any constraints..

Sanjay

[soniaarora]

Buffer=n ,' n' is not the number of rows . It is the buffer size in bytes.

Also it is not dropping the index, we have to first import with indexes=n and then create the index file and run it. I do this normally.

I want to know if there r any more ways to make import faster.

[anandkl]

Also make sure you set the statistics parameter to false,so that you dont generate statistcs when the import is going on.

regards
anandkl

[SANJAY_G]

Also it is not dropping the index, we have to first import with indexes=n and then create the index file and run it. I do this normally.

Of course, one should know how to recreate Index before droppping it.. There are several ways you can do it, one of them is what you explained.

Sanjay