Re: ORA-1691: unable to extend lobsegment
From: De DBA <dedba_at_tpg.com.au>
Date: Wed, 25 Jun 2014 12:55:30 +1000
Message-ID: <53AA3A22.6000909_at_tpg.com.au>
I don't think so - you'll still have to handle the actual out-of-space condition. That's why I'd first check why the LOB segment cannot be extended, e.g. because your tablespace is full? Do you expect the file to extend automatically, but does it fail to do so?
Date: Wed, 25 Jun 2014 12:55:30 +1000
Message-ID: <53AA3A22.6000909_at_tpg.com.au>
I don't think so - you'll still have to handle the actual out-of-space condition. That's why I'd first check why the LOB segment cannot be extended, e.g. because your tablespace is full? Do you expect the file to extend automatically, but does it fail to do so?
Cheers,
Tony
On 25/06/14 10:57, Nik Tek wrote:
> Hi Maureen and Tony,
>
> Thank you for quick response.
>
> Would "RESUMABLE_TIMEOUT" parameter solve the problem?
> My teammate feels it should solve the problem of ora-1691.
>
> Thank you
> Nik
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 25 2014 - 04:55:30 CEST