Hi all

I got the following error if I try to increase the size of datafile. Earlier
datafile size is 2048M.

ALTER DATABASE DATAFILE '/u07/../../data01.dbf' RESIZE 3042M;

ORA-01237: cannot extend datafile 8
ORA-01110: data file 8: '/u07/../../data01.dbf'
ORA-27059: skgfrsz: could not reduce file size
HP-UX Error: 27: File too large
Additional information: 2

Any clue?

Regards,






-----Original Message-----
From: Lynn Gagnon [mailto:[Email address protected]
Sent: Monday, February 28, 2005 6:29 PM
To: Sreedhar_Bhaskararaju
Subject: Re: ORA-1653: unable to extend table

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Hi,

You should resize your datafile for that tablespace or if the datafile is at
the maximum size that Oracle recommends (3GB), then add a new datafile to
that tablespace and this will solve your problem...



>>> "Sreedhar_Bhaskararaju "
<oracledba-ezmlmshield-x14229817.[Email address protected] 02/28/05 7:41 am
>>>
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


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