HI All,



The following error is persisting even though changing the extent size of a
table to maximum.



Thu Feb 24 05:32:36 2005

ORA-1653: unable to extend table TDB.COST by 3596 in tablespace
DATA01



The table space DATA01 has 8.4692908366533% free space as whole. Is it
necessary to increase the size or add a new datafile for the table space?
What will be possible solution?



NAME COST

SEGMENT_TYPE TABLE

TABLESPACE_NAME DATA01

BYTES 62578688

INITIAL_EXTENT 40960

NEXT_EXTENT 40960

PERCENT_INCREASE 0

EXTENTS 104

MAX_EXTENTS 2147483645



Thanks & Regards to all,

**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************

Oracle LazyDBA home page