How it works alter tablespace X default Storage...?

Hi all,

I did the command

Alter tablespace tbsA
default storage
( initial 1M

    next 512K
    pctincrease 0
    minextents 1
);

to fix the old value of tabsA

default storage
( initial 4K

   next 4K
   pctincrease 0
   minextents 1
);

but I still not finger out how it change inside the tablespace tbsA Do I need to backup the tablespace before executing this command ?

The same question for resizing the tablespace... But how can we know the current value INITIAL & NEXT using in the tablespace?

Thanks in advance for any idea...

H.V Received on Sun Jul 11 1999 - 22:48:51 CDT