Re: asm & smallfile limitation

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 30 Oct 2007 20:33:14 +0700
Message-ID: <3edcb66e0710300633s8c74902j335ff36ebec3a048@mail.gmail.com>

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

Received on Tue Oct 30 2007 - 08:33:14 CDT