Have you noticed that when you change the Next parameter of a table...
ALTER TABLE XYZ_TABLE STORAGE (NEXT 1M);
and then truncate the table
the original next parameter comes back?
Any way to keep the new NEXT after a truncate?
Rich
Oracle LazyDBA home page