Dear Patrick,
Ask your DBA to check the archive logs which might have
run out of extents. All Diary fields are created as clobs on an Oracle
database. What I would suggest is to recreate the diary field after adding
Oracle-Clob-Storage-In-Row to T in the ar.cfg file, which would allow all
the new clob fields to be added as a row and disallow extending it by 1024
in the tablespace. Hope this helps.
Regards,
Roney Samuel Varghese
On 6/7/07, patrick zandi <[EMAIL PROTECTED]> wrote:
** I did not think it was that.. I had 200 meg left..
But it was.. Thanks Fred.. you always come through..
On 6/7/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:
>
> ** It looks like you ran out of Tablespace or disk space
>
> ORA-01691: unable to extend lob segment
> ARADMIN.SYS_LOB0000112414C00118$$ by 1024 in tablespace ARSYSTEM
>
> Cause:
> While inserting records Oracle needed to extend a segment but there
> was insufficient space to allow it to do so, i.e. the tablespace is
> full.
>
> Possible Remedies:
>
> - Add additional datafiles to the tablespace.
> - Extend one or more datafiles in the tablespace.
> - Reduce the 'next' size for the table/segment to be consistent
> with the amount of free space available in any of the datafiles that
compose
> the tablespace.
>
>
> Fred
>
>
>
> ------------------------------
> *From:* Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG
> ] *On Behalf Of *patrick zandi
> *Sent:* Thursday, June 07, 2007 3:26 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* LOB Error
>
>
> ** Record 12115 : Failure during SQL operation to the database --
> ORA-01691: unable to extend lob segment
> ARADMIN.SYS_LOB0000112414C00118$$ by 1024 in tablespace ARSYSTEM (ARERR
> 552)
>
> Now I have a bigger issue.. I created a diary field, I then exported
> (arx) and imported to new Diary field. With above error::
> Oracle 10.2.0.3 DB
> --
> Patrick Zandi
>
>
> __20060125_______________________This posting was submitted with HTML in
> it___
--
Patrick Zandi __20060125_______________________This posting was submitted
with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
