Hi,
Did your file system is created thru vxfs option.
Check whether all this vsfs patches are applied for HP.
PHCO - 16090,15956,16220,16433,15721,16023,16313.
When exactly are you getting this error,as part of database
startup or intermittently during write operation.
What are all the other files in your database and their approx. sizes.
Make sure for the oracle thru which you are starting the database
as unlimited for "ulimit -f"
Can you just pass on the sysdef values to me.
Make your maxdsiz value to be 655360 and check it out.
Regards,
Sanjeev
-----Original Message-----
From: Sreedhar_Bhaskararaju
[mailto:oracledba-ezmlmshield-x51222342.[Email address protected]
Sent: Monday, February 28, 2005 6:55 PM
To: LazyDBA Discussion
Subject: RE: ORA-1653: unable to extend table
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.
************************************************************************
**
--------
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