You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Table refresh

in Database 4 comments

Hi Team,

We are on 19.28 version.


We regularly refresh tables from the production database to the test environment using Oracle Data Pump (impdp). Depending on the requirement, the import is performed using different options, TRUNCATE, or REPLACE (TABLE_EXISTS_ACTION=REPLACE).
When REPLACE is used, the existing table is dropped and recreated, resulting in the loss of grants and potentially other dependent objects or configurations.
Could you please provide a step-by-step, detailed action plan and recommended best practices for handling table-level refreshes from production to test.

Thanks,

SGU

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!