Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

cts123

Technical User
Feb 28, 2007
108
IN
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

 
Sam,

Try this:
Code:
ALTER TABLESPACE PSAPZSDEI default storage (MAXEXTENTS UNLIMITED);
Please confirm for us that this resolves your problem.

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

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

You well deserve a STAR for this quick support.

Regards,
Sam
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top