Re: asm & smallfile limitation

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@xxxxxxxxx> 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@xxxxxxxxx>:
> > 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
>

Other related posts: