OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01654 (Unable to extend index integration.IDXSRN05 by 1024 in tablespace users)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01654 [message #273342]

Wed, 10 October 2007 01:25

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

Report message to a moderator

Re: ORA-01654 [message #273368 is a reply to message #273342]

Wed, 10 October 2007 02:55

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: ORA-01654 [message #273424 is a reply to message #273368]

Wed, 10 October 2007 07:20

manoop
Messages: 8
Registered: October 2007

Junior Member

Its solved

Increased the size of the table space.

Regards
Manoop

Report message to a moderator

Re: ORA-01654 [message #274722 is a reply to message #273342]

Tue, 16 October 2007 23:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Why heading of this topic contains a Pool?

Report message to a moderator

Re: ORA-01654 [message #274740 is a reply to message #274722]

Wed, 17 October 2007 01:07

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Not a pool, a poll. OP clicked on the wrong button.

Regards
Michel

Report message to a moderator

Previous Topic:	What privileges for GATHER_TABLE_STATS on table in other schema
Next Topic:	procob installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:05:04 CDT 2024