Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to change a table's Initial Extent ?
Hi,
If your problem is only this try another aproach:
"alter table table_name
storage(next new_value_before_it_grows_to_big);"
done
J. Meirim
LEUNG CHI WAH wrote in message <3675d8cf.0_at_ruby.hknet.com>...
>hello,
>
>I have a table with a small initial extents and next extents
>In the past, the data growth is not very fast, so the parameter
>setting is quit satisfied.
>But in these few months , the data growth suddenly increase
>, it caught up many next extents.
>So we decide the change the parameter setting to meet
>the current situation.
>What is the best method to make this change?
>
>Are these methods workable?Which one is better?
>
>Method 1
>--------
>1. export the table
>2. drop the table
>3. create the table with new storage parameter
>4 load the data in
>
>Method 2
>--------
>
>1. create a new_table as
> select * from the old_table
> (new default storage parameter)
>
>2. drop the old_table
>
>3. rename the new_table to old_table
>
>Futhermore , what should I remember before I drop the table?
>What will be impacted if I drop the table
>(eg trigger, integrity Constraints, .... anything else?)
>
>Thanks a lot
>
>Tony
>
>
Received on Tue Dec 15 1998 - 12:51:05 CST