Method for migrating schema from PROD to DEV
From: SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>
Date: Mon, 24 Nov 2008 16:12:03 -0500
Message-ID: <8833494F383585499CB855121711D2630446BE3CD4@JBXEXVS02.fplu.fpl.com>
Date: Mon, 24 Nov 2008 16:12:03 -0500
Message-ID: <8833494F383585499CB855121711D2630446BE3CD4@JBXEXVS02.fplu.fpl.com>
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
- Export Schema in PROD
- Export Schema in DEV (for backup)
- Drop user in DEV
- Create basic user in DEV
- Import user in DEV
- Verify object count - PROD vs DEV
- Compile schema
Does this sound right?
Jeremy
P Consider the environment. Please don't print this e-mail unless you really need to.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 24 2008 - 15:12:03 CST