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
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