Just one thing about that.
If it stores something like blobs (I hate blobs), don't put an unlimited
maxsize.

-----Original Message-----
From: Gaurav Shrivastava
[mailto:oracledba-ezmlmshield-x77975141.[Email address protected]
Sent: Tuesday, May 29, 2007 8:50 PM
To: LazyDBA Discussion
Subject: RE: ORA-01654: unable to extend index PK_DTL_IX by 2048 in
tablespace EPICIXLARGE

Put MAXSIZE as unlimited for tablespace

-----Original Message-----
From: Efimov Dmitry
[mailto:oracledba-ezmlmshield-x39471261.[Email address protected]
Sent: Tuesday, May 29, 2007 9:48 AM
To: LazyDBA Discussion
Subject: RE: ORA-01654: unable to extend index PK_DTL_IX by 2048 in
tablespace EPICIXLARGE

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
>




---------------------------------------------------------------------
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




---------------------------------------------------------------------
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