Hi!

ORA-01654: unable to extend index string.string by string in tablespace
string
Cause: Failed to allocate an extent of the required number of blocks for
an index segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.

Regards,
Dmitri Efimov

> -----Original Message-----
> From: Tony [mailto:oracledba-ezmlmshield-
> x12017425.[Email address protected]
> Sent: Tuesday, May 29, 2007 5:35 PM
> To: LazyDBA Discussion
> Subject: ORA-01654: unable to extend index PK_DTL_IX by 2048 in
tablespace
> EPICIXLARGE
>
> Hi all,
>
> I am getting this error, but my tablespace EPICIXLARGE is locally
> managed and autoextensible. My index storage size is:
> initial size = 65536
> next size = 65536
> Increase by 0%
> Minimum number 1
> Max Number value = 2147483645
>
> Can anyone suggest what I should do to correct this error.
>
> Thanks
>
> Tony
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



Oracle LazyDBA home page