ORA-01630: max # extents (250) reached in temp segment in tablespace P 1

[cts123]

Hi,

I am new to Oracle world and the version of Oracle is 8.1.7. While doing following, I am getting following error. Any suggestion would be highly appreciated.

===============================

Request: Create Index ZTSARTOTAL-0 (VPERUSI/12/04/07/20:26)
E- SQL: ALTER TABLE ZTSARTOTAL ADD
E- (CONSTRAINT ZTSARTOTAL0 PRIMARY KEY
E- (MANDT,
E- ZZGJAHR,
E- ZZMONAT,
E- ZZHKONT,
E- ZZBUKRS,
E- ZZKUNNR,
E- ZZGSBER)
E- USING INDEX
E- PCTFREE 10
E- TABLESPACE PSAPZSDEI
E- STORAGE (INITIAL 0000000016 K
E- NEXT 0000002560 K
E- MINEXTENTS 0001
E- MAXEXTENTS 0250
E- PCTINCREASE 0000
E- FREELISTS 001))
ORA-01630: max # extents (250) reached in temp segment in tablespace PSAPZSDEI
DDL time___1: .1,374,270 milliseconds
E- The SQL statement was not executed
E- Index ZTSARTOTAL0 could not be set up in the database
Request for ZTSARTOTAL could not be executed

This is the error log I am getting.

============================

TIA ..

Regards,
Sam

 

[SantaMufasa]

Sam,

Try this:

ALTER TABLESPACE PSAPZSDEI default storage (MAXEXTENTS UNLIMITED);

Please confirm for us that this resolves your problem.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[cts123]

Mufasa,

You are the man. This worked like a charm. Thanks a lot.

You well deserve a STAR for this quick support.

Regards,
Sam