Home » RDBMS Server » Server Administration » Altering Next clause in oracle database objects
Altering Next clause in oracle database objects [message #374827] Thu, 05 July 2001 06:17
Rajee
Messages: 17
Registered: June 2001
Junior Member
Hi,
Consider, a table was created with NEXT clause in storage parameters set to 5M. Then data were inseted/updated in that table and now the table is using 5th extent(for example). In this suitation what will happen if we alter the next clause value to (say) 10M. Will the size of second extent change or it will remain the same. Alternately, what will happen to the size of second extent if the next clause value is reduced to 3M. Pls update me.
Thanks in advance.
With regards,
rajee
Previous Topic: Can I call C++ coded DLL with Oracle procedure? thanks!
Next Topic: Re: Database sweep
Goto Forum:
  


Current Time: Mon Dec 23 20:13:00 CST 2024