Re: Q: Tablespace management

Hi Vince,

another possibility is, to reorganize that tablespace. if you do so, you have to stop the SAP-system and to start SAPDBA.

Do you know the function of reorganization tablespaces?

kind regards

achim

Vince Laurent <eAddict_at_yahoo.com> wrote in message news:<jn3b9vs5706hlbnqtfsjmg88g3uld2tdm8_at_4ax.com>...
> I have a situation on one of our systems (Oracle 8.1.7.3).
> Seems there a few tables that have grown a bit. The NEXT
> extent for each of these tables is larger than the largest
> free chunk. Is there a way to adjust the NEXT on the fly
> (ie short of a reorg/imp/exp) to make the NEXT smaller?
> All the freespace chunks have been coalesed. My ultimate
> goal is to get these tables to thier own tablespaces but
> thanks to SAP they don't make it easy.
>
> Here is the space critical report:
>
> 04/10/2003 09:20:42 PRD sapdbci
> Critical objects checked on 04/10/2003 07:00:03
>
> Tablespace Table Freespace/kb Next extent/kb AutoExt.
> Maximum Total
> PSAPBTABD TST03 245,104 2,999,104 327,680 0
> PSAPBTABD GLPCA 245,104 2,999,104 327,680 0
> PSAPBTABD COEP 245,104 2,999,104 327,680 0
> PSAPBTABD BSIS 245,104 2,999,104 327,680 0
> PSAPBTABD ACCTIT 245,104 2,999,104 327,680 0
>
> Here is a list of the free chucks after a colaese. There are 90 or
> so...
>

[snip]
>
> Thanks for any help/pointers....
> I am running Oracle 8.1.7 on HP-UX
> Vince
Received on Mon Apr 14 2003 - 09:55:48 CDT