Saturday, May 19, 2018

Schema Refresh

Schema Refresh


Schema refresh are of two types, they are:

1. Refresh the database schema with production database.
2. Refresh the database schema from production to some other databsae like DEV/TEST.

Steps:
-Find the roles & privileges that are assigned to the schema.
-Capture source database schema objects count.
-Export database schema using EXP/EXPDP utililty.
-Recreate the schema with default tablespaces and allocate quota.
-Make required roles & privileges for the schema.
-Import the dump file using IMP/IMPDP into the target database.
-Recompile invalid objects.
-Gather schema statistics after the refresh.

No comments:

Post a Comment