| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
