Re: Q: Reorg an SAP tablespace

Vince Laurent wrote:
> So you are saying if I started with a 64K extent
>
> create tablespace PSAPODSD
> datafile 'c:\oradata\blahblah.dbf' size 2G
> extent management local
> autoallocate;
>
> it would take into account all the available chunks and actually use smaller chunks when trying to allocate for a lager table?
> Won't I end up in the same situation I am now with the developers always adding/removing data and therefore changing the sizing
> requirements?
>
> This sounds like it might be the way to go.

Autoallocate quickly figures out that a table is larger.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:25322140091802

What is real important is that only a few sizes are used, so it is generally easy to re-use them when necessary. Bizarro cases can be demonstrated like in
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:5549302357655 but they really require some special circumstances.

jg

--
@home.com is bogus.
Quality.  http://www.synpep.com/
http://www.signonsandiego.com/uniontrib/20060524/news_1b24biotech.html