keeping the Next table parameter??

keeping the Next table parameter??

 

  

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