PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Create Indexes SQL Script fails

Hi,

On the step of "Running the Create Indexes SQL Script" in Change Assistant, I faced an error on one of the table due to duplication of data. However, I have rectified the data, but now when I am going to restart the Step it goes to error "The operation failed because an index or statistics with name 'PS_ACAD_ORG_CAF' already exists on table 'PS_ACAD_ORG_CAF'." (This is the first script in CP_crtidx file).

Kindly guide how to proceed forward?

Thanks

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