PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Alter in Place and Alter by Table Rename is generating same DDL script

I am trying to create a DDL from App Designer in Development for a record that I added new columns. I selected "Alter in Place" and it still created a script that was similar to "Alter by table rename" i.e. it is creating temp table, copy data from original table to temp table, drop the original table, rename the temp table as original table followed by index creation which is not expected for when Alter in Place option selected. Any idea what could be wrong with the record ?

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