Maxextent of PSAPTEMP = 0 : normal ?

366 Views

Hello,

SAP release ; ECC6

Oracle release : Oracle 10.2

Unix : Solaris 10

We had the following error this morning while trying to reorganize an index :

<b>ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP</b>

I was about to add new datafile to the tableblace PSAPTEMP but I noticed strange parameters related to this tablespace :

Tablespace Init ext.(Kb) Next ext.(Kb) Min ext. Max ext. Pct-Inc.

PSAPSR3 64 0 1 Unlimited 0

PSAPSR3700 64 0 1 Unlimited 0

PSAPSR3DB 64 0 1 Unlimited 0

PSAPSR3USR 64 0 1 Unlimited 0

<u>PSAPTEMP 1.024 1.024 1 0 0</u>

PSAPUNDO 64 0 1 Unlimited 0

SYSAUX 64 0 1 Unlimited 0

SYSTEM 64 0 1 Unlimited 0

Tablespace Size (kb) Free (kb) Used (%)Tab/ind Extents

PSAPTEMP 2.324.480 2.324.480 0 0 0

The Tablespace is empty.

The Maxextent of tablespace PSAPTEMP is null, in all our ECC6 environnements,

and has never been modified. I wanted to change it to "unlimited", I've searched in BRGUI, but I couln't find where i can do that. I presume it can be done using an alter command ?

So my questions are :

1/ Is it a "normal" setting in Oracle 10.2 to have the maxextent of PSAPTEMP = 0

2/ If not, how can I change, the maxextent size of PSAPTEMP ?

Thank you for your attention.

Any useful help would be highly appreciated.

Best Regards.