Home » RDBMS Server » Server Administration » ORA-01654 (Unable to extend index integration.IDXSRN05 by 1024 in tablespace users)
ORA-01654 [message #273342] Wed, 10 October 2007 01:25 Go to next message
manoop
Messages: 8
Registered: October 2007
Junior Member
Hi guys

I got this error and i'm waiting for your valuable suggestion



ORA-01654 Unable to extend index integration.IDXSRN05 by 1024 in tablespace users



What to do?


Thanks in advance

Manoop
Re: ORA-01654 [message #273368 is a reply to message #273342] Wed, 10 October 2007 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Find the reason (for instance max extents reached)
2/ Fix it

Regards
Michel
Re: ORA-01654 [message #273424 is a reply to message #273368] Wed, 10 October 2007 07:20 Go to previous messageGo to next message
manoop
Messages: 8
Registered: October 2007
Junior Member
Its solved

Increased the size of the table space.


Regards
Manoop

Re: ORA-01654 [message #274722 is a reply to message #273342] Tue, 16 October 2007 23:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Why heading of this topic contains a Pool?
Re: ORA-01654 [message #274740 is a reply to message #274722] Wed, 17 October 2007 01:07 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not a pool, a poll. OP clicked on the wrong button.

Regards
Michel
Previous Topic: What privileges for GATHER_TABLE_STATS on table in other schema
Next Topic: procob installation
Goto Forum:
  


Current Time: Mon Dec 05 15:12:01 CST 2016

Total time taken to generate the page: 0.05335 seconds