Everybody ... thanks for your help on this.
What happened is that I had increased the extents
from 121 to 500, but because there was an
existing session that had the object I
had to wait for that session to end before
the 500 extents were noticed.
So, I did everything right, I just had to wait
Check for both tablespaces maxextents 1) target tablespace and 2) temp
tablespace. It appears that block_size of your database is 2K thus default
maxextents are 121. You can alter both tablespaces like
alter tablespace tablespace_name default storage(maxextents unlimited);
Regards
Rafiq
Rep
l [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 13, 2002 12:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Anybody get a 1630 error when trying to add an index ?
>
>
> I have been trying to add an index
> to a index tablespace and I keep
> getting a 1630 error.
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
Have you checked the amount of max extents in the tablespace? The error you
listed is saying that it is running out of extents in dealing with temporary
objects created in the tablespace being used.
Bryan
-Original Message-
Sent: Monday, May 13, 2002 3:33 PM
To: Multiple recipients of li
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