ora-01654 error

[Former Member]

Hi all,

We are getting this following short dump in our system.

ora-01654 unable to extend index sapsr3.d010inc~1 by 8192 in the tablespace psapsr3701.

When i checked in the db02 the tablespace was having sufficient space.I tried to add another data file to it.

I was getting the below error then.

ORA-01119: error in creating database file

'/oracle/DS3/sapdata1/sr3701_9/sr3701.data9'

ORA-27040: file create error, unable to create file

Could someone help us in understanding the issue.Thanks.

[Former Member]

Dear Ambarish,

Please give environment details.

Did you tried anything else than mentioned above post? May be try a quick restart of DB should work ..

Regards

Shailesh Mamidwar

[Former Member]

Hi Shailesh,

OS : Redt hat

restart of DB thats not a very good idea.Could you please suggest anything aprt from that.Thanks.

[Former Member]

is your datafile in autoexend mode? maybe your disk is full so that it cannot extend it anymore?