This error is due to you NEXT EXTENT size of 40960. The tablespace does not have a contiguous chunk of free space for the table segment. Reduce this next extent or increase the tablespace size chunk.

-----Original Message-----
From: Boog Boog Jean Michel [mailto:oracledba-ezmlmshield-x35488485.[Email address protected]
Sent: Monday, February 28, 2005 7:06 AM
To: LazyDBA Discussion
Subject: RE: ORA-1653: unable to extend table

As i see, the size of your tablespace is not enormous so you can increase it rather than adding a new file.

-----Message d'origine-----
De : Sreedhar_Bhaskararaju
[mailto:oracledba-ezmlmshield-x14229817.[Email address protected] Envoyé : lundi 28 février 2005 13:41 À : LazyDBA Discussion Objet : ORA-1653: unable to extend table


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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page