Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to copy production tables with object_version_number into test

edited Jun 12, 2012 1:34AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered
Hello,

I am working with the hr.per_all_people_f table in TEST.  I created a table to save the existing hr.per_all_people_f table.  I wanted to put the save table back, so I truncated hr.per_all_people_f, and inserted the saved records back.  However, all of the records now have object_version_number 1, rather than one employee possibly having more than one record, each with a different object_version_number.  How can I get the production table/records into test while preserving the object_version_number?

Thanks!

Donna

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