Re: Re: Text Index Create takes forever
Date: Mon, 25 Nov 2019 15:33:14 +0100 (CET)
Message-ID: <2032535677.29697.1574692394394_at_bluewin.ch>
Hi Mladen,
original TBS has reached max extents. TT does not help. As soon as the table data is moved rowids change and index rebuild is unavoidable. Bad stuff is that resync seems to always reparse. :(
Reagards
Lothar
----Ursprüngliche Nachricht----
Von : gogala.mladen_at_gmail.com
Datum : 25/11/2019 - 15:08 (MN)
An : oracle-l_at_freelists.org
Betreff : Re: Text Index Create takes forever
Hi Lothar!
Why not use transportable tablespace mechanism to just move the tablespace files to different storage? The table would stay where it is, but the files would be relocated. Alternatively, how about moving everything except the monster table to different tablespace?
Regards
On 11/25/19 8:17 AM, l.flatz_at_bluewin.ch wrote:
> Hi,
>
> we have a 8oo million rows table that we want to migrate to an other
> Tablespace.
> The key point is the migration of a Text index based on a BLOB (Secure
> file) that contains PDF.
> The recreation of the Index takes weeks. It is CPU bound and the time
> is spend parsing the BLOB.
> So far it seems the best Strategy to gfo as high parallel as possible.
> Any idea to speed this up? DB version is 12.2.0.1.
>
> Regards
>
> Lothar
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 25 2019 - 15:33:14 CET