How to speed up oracle Import

How to speed up oracle import the traditional imp command, if only data is processed during import, tens of millions of data is simply
"Mao Yu", the key is to re-index each table after it imports data. Www.2cto.com Imports one index and one commit, which is like using a loop to insert 10 thousand pieces of data and using statemenet. addBatch (query); the efficiency is the same, it must be faster and more efficient. Therefore, in this case, we recommend that you perform the following analysis on the imp import command:-segmented submission-set buffer-pilot data re-import index www.2cto.com, our original imp command looks like this: SQL code imp user2/pwd fromuser = user1 touser = user2 file = file commit = y feedback = 10000 buffer = 10240000 ignore = y rows = y indexes = n imp user2/pwd fromuser = user1 touser = user2 file = file commit = y feedback = 10000 buffer = 10240000 ignore = y rows = n indexes = y. No, the pilot data rows = y indexes = n, and then the index rows = n indexes = y commands are successively initiated. When only data is imported It takes only 15-20 minutes for a. dmp package of about 14 GB in the same hardware and software environment, and 25-27 minutes for the last index creation statement.