Re: Changing table initial extent size

heppy62_at_yahoo.co.uk (heppy) wrote in message news:<2ebb4802.0202201426.12f39868_at_posting.google.com>...
> Ronen,
>
> You can't (8.1.7); the initial extent size can only be specified when
> creating a table and the initial extent is always allocated when a
> table is created. You can only change the size of the next extent of
> a table.
>
> If you need to change the initial extent size the table must be
> recreated.
>
> Regards
>
> ronench_at_hotmail.com (Ronen) wrote in message news:<d66fd176.0202200658.468cd247_at_posting.google.com>...
> > How to change the table initial extent size, from an initial value of 100M to 1M.
> >
> > Thanks,
> >
> > Ronen

An easy way to rebuild the table without too much work is to use the move command.

alter table scott.table1 move tablespace users storage (initial extent xxK next yyK minextents 1 maxextents 999...);

This will preserve all of the referential intergrity (foreign keys as so forth) as well as any references in plsql code and grants. It is one of the cleanest ways to rebuild a table. You could just alter table scott.table1 move tablespace users but this assumes you want the same storage parameters. This function is very much like the alter index rebuild command.

This is only available in 8i...

Good luck. Received on Thu Feb 21 2002 - 23:59:19 CET