RE: Method for migrating schema from PROD to DEV
Date: Mon, 24 Nov 2008 16:26:53 -0500
Message-ID: <21469B88E0EA11498818517F210335310455B935@EPRI17P32001A.csfb.cs-group.com>
- Make sure all of the production tablespaces exist in dev, and with sufficient space
- Make sure all production roles exist in dev
- Make sure to create dev user with same system privileges, role grants, and tablespace quotas as production
OR
3. Don't drop dev user; just drop all its schema objects
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of SHEEHAN, JEREMY
Sent: Monday, November 24, 2008 4:12 PM
To: oracle-l_at_freelists.org
Subject: Method for migrating schema from PROD to DEV
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.
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 24 2008 - 15:26:53 CST