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@xxxxxxxxxx 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
