OraFAQ Forum: Server Administration » ORA-01654:unable to extend index HR.XXHRS_PER_PEOPLE_F

Home » RDBMS Server » Server Administration » ORA-01654:unable to extend index HR.XXHRS_PER_PEOPLE_F_N1 by 35 in

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

ORA-01654:unable to extend index HR.XXHRS_PER_PEOPLE_F_N1 by 35 in [message #137097]

Tue, 13 September 2005 04:23

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Subject - ORA-01654: unable to extend index HR.XXHRS_PER_PEOPLE_F_N1 by 35 in
tablespace HRX

Hi chaps!

hope my message finds everyone in best of health and sprits!

I've got this error and need your suggestion

I have ran this

select db.FILE_NAME,
db.AUTOEXTENSIBLE,
db.INCREMENT_BY,
db.USER_BLOCKS,
t.INITIAL_EXTENT,
t.NEXT_EXTENT,
t.EXTENT_MANAGEMENT
FROM dba_data_files db,
dba_tablespaces t
where db.TABLESPACE_NAME = t.TABLESPACE_NAME
and t.TABLESPACE_NAME = 'HRX'

and got this -->

/export/H003_overflow/H003_index/hrx01.dbf

and see the df -k for export

35529837 30403424 4771115 87% /export

plz help me, what I do

Regards
Puneet

Report message to a moderator

Re: ORA-01654:unable to extend index HR.XXHRS_PER_PEOPLE_F_N1 by 35 in [message #137106 is a reply to message #137097]

Tue, 13 September 2005 05:16

deepa_balu
Messages: 74
Registered: March 2005

Member

Hi,

Check whether the Autoextend is on or off.

If it is off then, it will not grow beyong the maxsize of the Datafile.

Report message to a moderator

Re: ORA-01654:unable to extend index HR.XXHRS_PER_PEOPLE_F_N1 by 35 in [message #137134 is a reply to message #137106]

Tue, 13 September 2005 07:10

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Quote:

ORA-01654 unable to extend index string.string by string in tablespace string

Cause: Failed to allocate an extent for index segment in tablespace.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Report message to a moderator

Re: ORA-01654:unable to extend index HR.XXHRS_PER_PEOPLE_F_N1 by 35 in [message #137187 is a reply to message #137097]

Tue, 13 September 2005 12:17

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

thanks everyone!

its been great to have someone with always when we stuck in some issues

Anyways I got solution for that, this is what I did..

may if someone also stuck with this.... he can get the solution!

select file_name,bytes/1024/1024 from dba_data_files where tablespace_name='HRX';

and received

/export/H003_overflow/H003_index/hrx01.dbf 750

then issue

alter database datafile '/export/H003_overflow/H003_index/hrx01.dbf' resize 1500M;

regards
Puneet

Report message to a moderator

Re: ORA-01654:unable to extend index HR.XXHRS_PER_PEOPLE_F_N1 by 35 in [message #137477 is a reply to message #137187]

Thu, 15 September 2005 06:19

Jay Munshi
Messages: 30
Registered: July 2004

Member

or you can just do
ALTER DATABASE
DATAFILE '/uxx/u03/oradata01/eftiad/eftiad/indx01.dbf'
AUTOEXTEND
ON NEXT 40K;

cheers!
Jay Munshi
http://jaydba.tripod.com

Report message to a moderator

Previous Topic:	No Listner (how to create listner servive on Unix box)
Next Topic:	Farsi font support in Oracle 10gR1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 23:25:55 CDT 2024