Re: asm & smallfile limitation

hm....

i got this on metalink...and this is match with my oracle version except OS.

Bug No. 	6281407
Filed 	27-JUL-2007 	Updated 	30-AUG-2007
Product 	Oracle Server - Enterprise Edition 	Product Version 	10.2.0.3
Platform 	Solaris Operating System (SPARC 64-bit) 	Platform Version 	10
Database Version 	10.2.0.3 	Affects Platforms 	Generic
Severity 	Minimal Loss of Service 	Status 	Code Bug (Response/Resolution)
Base Bug 	N/A 	Fixed in Product Version 	No Data

Problem statement:

GOT ORA-1688 TABLESPACE HAS AUTOEXTEND ENABLED WITH DISKSPACE AVAILABLE btw thanks for the respons.

regards
ujang

On 10/30/07, Frits Hoogland <frits.hoogland_at_gmail.com> wrote:
> unhvsperft01:/oracle/client/9.2.0.4/bin$ ./oerr ora 1691
> 01691, 00000, "unable to extend lob segment %s.%s by %s in tablespace %s"
> // *Cause: Failed to allocate an extent for lob segment in tablespace.
> // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
> // files to the tablespace indicated.
>
> your session is unable to allocate an extent for the lobsegment in the
> tablespace, because the tablespace has ran out of space. make more space
> available by adding a datafile.
>
> frits
>
>
> On 10/30/07, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> > peter,
> >
> > this is the error
> >
> >
> >
> > ORA-1691: unable to extend lobsegment
> AUDITTRAIL.SYS_LOB0000059312C00003$$ by 8192 in tablespace
> AUDITEXTENDEDINFO_TABLOB
> >
> > ORA-1691: unable to extend lobsegment
> AUDITTRAIL.SYS_LOB0000059312C00003$$ by 128 in tablespace
> AUDITEXTENDEDINFO_TABLOB
> >
> > ORA-1691: unable to extend lobsegment
> AUDITTRAIL.SYS_LOB0000059312C00003$$ by 8192 in tablespace
> AUDITEXTENDEDINFO_TABLOB
> >
> >
> > --
> >
> > ..ujang
> > "There are four types of lies - lies, damn lies, statistics and average"
> > http://ujang-id.blogspot.com
> >
> >
> >
> > On 10/29/07, Peter van Rijn <petervanrijn_at_gmail.com > wrote:
> > > Which *exact* error message did you get?
> > > There can be numerous reasons why it is unable to extent.
> > >
> > > Peter
> > >
> > >
> > > 2007/10/29, Ujang Jaenudin < ujang.jaenudin_at_gmail.com >:
> > >
> > > > all,
> > > >
> > > > I have this machine:
> > > > solaris 10
> > > > oracle 10.2.0.3 rac 2 nodes
> > > > asm
> > > >
> > > > a smallfile tablespace with 5 datafiles, each 32GB.
> > > >
> > > > but when datafiles rech 20GB, oracle complaint that unable to extent
> on that
> > > > tablespace....
> > > > does anyone have the experience? or have metalink note?
> > > >
> > > > --
> > > > regards
> > > > ujang

--
http://www.freelists.org/webpage/oracle-l