1Z0-997-25 Question 153
Select 2You have just used the Data Pump network import feature to migrate an on-premises Oracle Database 19c to an Oracle Autonomous Database (ADB) in OCI. The import completed, but you see warnings about some objects that remain invalid and user privileges that do not match the on-premises configuration. Which two actions should you take next to ensure a properly functioning ADB environment?
- A
Recompile the invalid objects on the ADB instance by running the UTLRP.SQL script.
- B
Rerun the import with the FULL=Y parameter to overwrite the existing schemas and objects in the ADB.
- C
Manually reassign or grant missing user privileges using an admin user in the ADB.
- D
Drop and recreate the target schemas on the ADB, then re-run the migration from scratch.
Show answer and explanation
Correct answers: A, C
Explanation
In real-world migrations using Data Pump network import, invalid objects and missing privileges are common issues. Best practices include running UTLRP.SQL to recompile any invalid objects and then granting privileges to match the source environment. Optionally, you can use Oracle-supplied or custom scripts to validate and apply privileges. For more information, consult the official Oracle Cloud Infrastructure and Oracle Database documentation on using Data Pump and post-migration validation steps.
- A. Correct.
Correct. Running UTLRP.SQL in ADB will compile any invalid objects. This is a valid and common step after Data Pump imports to ensure all objects become valid, especially when migrating between different environments.
- B. Incorrect.
Incorrect. Rerunning the import with FULL=Y might overwrite changes and objects, potentially causing inconsistencies or data loss. This is not typically recommended to fix invalid objects post-migration.
- C. Correct.
Correct. Some system or object privileges might not have transferred correctly, especially if you used a network import. Assigning these privileges manually using an admin account ensures the migrated database mirrors the original privileges.
- D. Incorrect.
Incorrect. Dropping and recreating target schemas is too disruptive and time-consuming for a routine cleanup of invalid objects and missing privileges, especially after a mostly successful import.