Database Administration (MOSC)

MOSC Banner

constraints remain "NOT VALIDATED" after dbms_redefinition

edited Jul 18, 2018 11:56AM in Database Administration (MOSC) 8 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center