Moving 2k segments (800GB) via dbms_redefinition .
Hi,
on my 10.2.0.3 RAC I have to move like 2k segments (mostly partitioned, few subpartitioned) totals of 800GB into different tablespace.
Few of them are in use so should stay online .
The obvious choice for me was dbms_redefinition , and as a time is not crucial here I thought maybe treat all
that segments that way .
Here goes my problem and solutions I've found and ask You to elaborate .
1. Need to create like 2k intermin segments into target tablespac .
I'll use impdp metadataonly for table segments with remaping of tablespace name .