constraints remain "NOT VALIDATED" after dbms_redefinition
Hello community,
I have to alter tables with basicfil-LOBs to use securefile-LOBs. I use the dbms_redefinition package for this and the only modification i do is the lob-store-Parameter:
DBMS_REDEFINITION.REDEF_TABLE(
uname => table_rec.owner,
tname => table_rec.table_name,
lob_store_as => 'SECUREFILE');
After successful finish of the procedure, I noticed that the most constraints remain as "not validated".
In a second step, I need to validate these constraints.
According to Doc ID 18549238.8 and Bug 13526773, the problem should be fixed in 12.1.0.1 already. (We are running 12.1.0.2)
Is there a way to avoid the invalidation of these constraints?
best regards