Re: Slow import

From: "Robert Doolittle" <robdool_at_centrelab.com> >> Basically said > import was slow for pre-allocated table with index(es) and increasing buffer did not seem to help. <<

Try dropping the index, import with indexes=n and a larger buffer, and rebuild the index after the import is done. That should help.    

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sat Feb 14 1998 - 00:00:00 CST