Method for migrating schema from PROD to DEV

From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 24 Nov 2008 16:12:03 -0500

Does anyone have a proven method for migrating a schema from PROD to DEV?  I 
plan on using export/import, but I've got a few reservations about the 
migration steps.

I think the best method would be to do the following

1. Export Schema in PROD
2. Export Schema in DEV (for backup)
3. Drop user in DEV
4. Create basic user in DEV
5. Import user in DEV
6. Verify object count - PROD vs DEV
7. Compile schema

Does this sound right?

Jeremy
P Consider the environment. Please don't print this e-mail unless you really 
need to.

Follow-Ups:

RE: Method for migrating schema from PROD to DEV
From: Baumgartel, Paul

Re: Method for migrating schema from PROD to DEV
From: Andre van Winssen

References:
- Any-one know how to eliminate PLANNED downtime with Oracle RAC?
  - From: Fahrenfort, Keith (HP Shared Solutions Architect for Oracle)
- Re: Any-one know how to eliminate PLANNED downtime with Oracle RAC?
  - From: LS Cheng

Method for migrating schema from PROD to DEV

Other related posts: