The error occurs after doing a rather large select. From what I have read, the pctincrease has no affect in version 7. We are selecting approximately 20 million records.
Any advice is appreciated.
Steve Steve, I want to wish you good luck on your new DBA role. There is much to learn, and two days is not enough to get up to speed. This message should hopefully help get you going. Also, the pctincrease DOES have an effect in Oracle7. You have it set to 1.