Is your file 2Gbs? Cause that's looks like your maxsize. If so make it
unlimited or add another datafile.

I assume quota is not an issue.

I believe locally managed will ignore initial, next.

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Tony
[mailto:oracledba-ezmlmshield-x12017425.[Email address protected]
Sent: Tuesday, May 29, 2007 9:35 AM
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