RE: Anybody get a 1630 error when trying to add an index ?

[Whittle Jerome Contr NCI]

Title: RE: Anybody get a 1630 error when trying to add an index ?

Mike,

Does you index creation script have a storage clause?  It should look something like below.

CREATE INDEX FLIGHT_LEGS_NDX1 ON
  FLIGHT_LEGS(D_ACTUAL_TIME, EVENT_TYPE)
  TABLESPACE ASIFNDX PCTFREE 10 
  STORAGE(INITIAL 160K NEXT 160K PCTINCREASE 0 MAXEXTENTS 500);

Depending on the projected size of the index, you may need to change the Initial and Next to something like 5M.

Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145

-----Original Message-----
From:   Johnson, Michael  [SMTP:[EMAIL PROTECTED]]

I have been trying to add an index
to a  index tablespace and I keep
getting a 1630 error.

I have 500 extents , but it says the
max extents are only 121 and they
are filling up.

Maybe my dendrites have been temporarily
fried and it is something simple.

Thanks for your time in advance.

Mike