Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How it works alter tablespace X default Storage...?
Trying to understand your post, it seems to be a bit confused
1 altering the default storage clause will apply to NEW objects only. No
existing objects are changed.
2 If you want to change existing objects, initial cannot be changed, next
can be changed. However, this needs to be done object by object (or by means
of a script)
3 if you do want to change initial, you need to export everything in that
tablespace, drop the current objects, create them with the correct sizing
and import the file you exported.
Hth,
Sybrand Bakker, Oracle DBA
Huy Vu <huyv_at_usa.net> wrote in message
news:iCdi3.10548$jl.17088182_at_newscontent-01.sprint.ca...
> 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 Mon Jul 12 1999 - 00:07:00 CDT