Re: r12.2

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/r12-2-tp3470p3489.html

It just do the following update.
Note that I didn't include the select of that update, but it is clear that It flips the snapshot info in ad_snapshots. I mean it makes type C -> P and P -> C and G -> Q and Q -> G)

So, the same logic of the cutover applies for it as well..

update ad_snapshots
  set    snapshot_type=DECODE(snapshot_type, 'C', 'P', 'P', 'C',
                                            'G', 'Q', 'Q', 'G')