As long as your disk space is adequate :)
-----Original Message-----
From: Gaurav Shrivastava
[mailto:oracledba-ezmlmshield-x77975141.[Email address protected]
Sent: 29 May 2007 14:50
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
**************************************************************************
IMPORTANT NOTICE
This e-mail may contain information that is privileged, confidential or
otherwise protected from disclosure. It must not be used by, or its contents
copied or disclosed to persons other than the intended recipient(s).
If you have received this e-mail in error, please notify us immediately at
[Email address protected] and delete this e-mail from your system.
Any liability (in negligence or otherwise) arising from any third party
acting, or refraining from acting, on any information contained in this e-mail
is excluded.
It is the responsibility of the recipient to ensure that this message and its
attachments are virus free. UAP Limited are not responsible for any reliance
placed on the information contained in this e-mail and excludes all liability.
**************************************************************************
Oracle LazyDBA home page