Home » SQL & PL/SQL » SQL & PL/SQL » max extents
max extents [message #250881] Wed, 11 July 2007 13:37 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

I am trying to create the index which has the following parameter.

STORAGE (
INITIAL 3M
NEXT 3M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
it is giving me the following error after i run.
ORA-01632: max # extents <2049> reached in index lc_feed.sys_c0042940.

I have put the maxextents parameter to unlimited. I have no idea why the extents stops when it reaches to <2049>

thanks in advance

[Updated on: Wed, 11 July 2007 13:37]

Report message to a moderator

Re: max extents [message #250885 is a reply to message #250881] Wed, 11 July 2007 13:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't put it to unlimited you put it to 2147483645, use unlimited instead.
Btw, this clause is useless in LMT that you should use.

Regards
Michel
Re: max extents [message #250889 is a reply to message #250885] Wed, 11 July 2007 14:02 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Thanks for you reply. i Tried maxextents = 2147483645. When i try to load the data in there, It gives me the following error.

ERROR:
ORA-01632: max # extents (2049) reached in index LC_FEED.SYS_C0042940


So i am trying to figure out why extent is getting stop when it reached to (2049) even though i put the extent to unlimited.

Much much Appreciated.

Thanks again
Re: max extents [message #250890 is a reply to message #250889] Wed, 11 July 2007 14:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I said don't try 2147483645, try UNLIMITED.

What is your Oracle version.

Regards
Michel

[Updated on: Wed, 11 July 2007 14:07]

Report message to a moderator

Re: max extents [message #250894 is a reply to message #250890] Wed, 11 July 2007 14:12 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Sorry, i forgot to mention you before i have tried with both, unlimited and 2147483645. But still getting the same error.
the oracle version 9.2.0.6
Greatly appreciated

Thanks

[Updated on: Wed, 11 July 2007 14:13]

Report message to a moderator

Re: max extents [message #250901 is a reply to message #250894] Wed, 11 July 2007 14:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems you have an old block format.
Create a new tablespace and move your objects in this one.

Regards
Michel
Re: max extents [message #250914 is a reply to message #250881] Wed, 11 July 2007 15:39 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
qasim845 wrote on Wed, 11 July 2007 14:37
I
it is giving me the following error after i run.
ORA-01632: max # extents <2049> reached in index lc_feed.sys_c0042940.



What is it?
I highly doubt you created an index on the lc_feed table called sys_c0042940. This is a system created index. You'll have to look at the storage parameters for that index. It is most likely a unique index created as part of a primary key creation. It would be better to use the proper syntax for a primary key creation.
Re: max extents [message #250995 is a reply to message #250914] Thu, 12 July 2007 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think it is part of an import or an extract from dbms_metadata.

Regards
Michel
Re: max extents [message #251129 is a reply to message #250881] Thu, 12 July 2007 07:42 Go to previous message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Thanks for micheal and joy. But at the end what joy_division mentioned, That is exactly what was happening. Thanks alot dude.
Previous Topic: finding common rows
Next Topic: how to prevent Insert in Before Insert trigger???
Goto Forum:
  


Current Time: Wed Dec 07 16:27:18 CST 2016

Total time taken to generate the page: 0.10801 seconds