Re: Oracle 12c extended VARCHAR - LOB segment grows indefinitely

From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Mon, 25 Jan 2016 17:04:44 +0100
Message-ID: <56A6479C.3000001_at_mgm-tp.com>



Jonathan,

> A CLOB column will have the same problem. I think I came across this
> problem quite a long time ago so it may be logged as a bug
> somewhere.

We have been running this on 11.2 for years now using a CLOB column and never encountered a problem.

> If you can't find it as a bug on MoS raise it.

I already searched for it and there either is no bug, or I am not able to find the right search terms ;)

> If you're licensed for the partition option you could avoid the growth and the down-time
> by adding in a step to recreate the table:
> (I haven't tested this with a CLOB/extended varchar2 in place):
>
> Create the table as a hash partitioned table with one partition
> Create a non-partitioned clone
> Do your delete/insert
> truncate the clone
> insert append from the partition to the clone
> exchange partition with table - online (12c feature).

Thanks for the hint, I will test that. But I think if this indeed is a bug, then we will probably switch back to CLOBs rather than changing the process that fills the tables.

Thomas

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 25 2016 - 17:04:44 CET

Original text of this message