change "Initial" storage option (I need to reduce sizes)

[patnams]

Hi all,

I have 250 tables in my schema (I did not create it). Most of the tables have "initial" as 10MB but they wont even takeup 10K.

My backup are taking toomuch time because of this.

How can I change the settings without recreating tables.
I dont want to messup Indexes/constraints/referential.

Any advise would be really helpful.

Thanks

[sreddy]

Use ALTER TABLE MOVE CLAUSE and move it to a different tablespace with diffrent storage clause. See the syntax.

[pando]

you can move to the same tablespace as well

[dave777]

actually you can move to the same tablespace, it there is enough space.

[patnams]

I just tried on a test table. I can see changes block location.
Thanks very much.

When you were refereing to space in TBS, you mean enuf space for that table ? I suppose the old segment is released after the table is moved.

[pando]

you have to rebuild the indexes after move your table, regarding space you need more space during the movement after movement the old table is dropped