Hi,

I am planning to refresh my DEV instance from PROD. Following is my
question.

I have same users on DEV instance as those on PROD but with different
passwords. When I refresh the DEV from PROD I will get the users from PROD,
but the passwords will be of those in PROD.

1. Can I export the DBA_USERS table (which stores the passwords) of DEV,
refresh DEV from PROD and then import the DBA_USERS back. Is it a right
approach?

2. What in case I have different users in DEV and PROD?

3. How do you take care of this scenarios in your environments?

4. This is a different question, but related to REFRESH. After refreshing
DEV from PROD, when I query select * from global_name shows PROD instead of
DEV. How to resolve this?

Thanks
Ifti.
Oracle LazyDBA home page