Re: Help with Downsizing Tablespaces

Please note initial applies to the table level, next also, and only autoextend to the tablespace level.
An autoextend of 500k is awfully little, and setting it to 50k will only make things worse.
I don't know how you get at 14.6 Mb after downsizing, the only thing you should know is how much space is occupied now. Autoextend has nothing to do with that. 50 Mb is for a relatively small tablespace. If your database starts to grow you would end with many, many files added. I would rather make sure all used space is contiguous (and hence export and import)
and resize the tablespace itself (alter database datafile '<file_name>' resize, if you are on 7.3 (and may be even 7.2) or higher.

Hth,

--
Sybrand Bakker, Oracle DBA

Chris Forlano <cforlano_at_nortelnetworks.com> wrote in message news:37F92240.CBFABAE4_at_nortelnetworks.com...
> I have a tablespace set to a size of 50MB.
> Currently, the initial, next, and autoextend is 500k ... making it
> 43.7MB.
> I would like to downsize these values to 50k each ... reducing the
> tablespace 14.6MB.
>
> How can I do this?
> I does not appear that I can use alter tablespace.
> Do I need to do an export followed by an import?
>
> Better yet, should I be doing this?
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> Automation Development
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
>
>
Received on Mon Oct 04 1999 - 23:50:50 CDT