PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to migrate Record Property without Altering table with Change Assistant?

edited Aug 14, 2018 9:20AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

Hello helpful people.

Is there a way to use Change Assistant to migrate a package that contains a Record definition and NOT automatically have build SQL run (CREATE/ALTER)?

I have a record definition with a Query Security Record property that needs updated - and that's the only changed.  However, whenever I create a Package and migrate with Change Assistant, the record is always built.  I can set to skip CREATE if record exists (which is does and the CREATE is skipped).  But the ALTER runs every time - and this is a large table that takes too long to run the alter.

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