RE: Method for migrating schema from PROD to DEV

1.  Make sure all of the production tablespaces exist in dev, and with
sufficient space
 
 
2.  Make sure all production roles exist in dev
 
 
3.  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@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of SHEEHAN, JEREMY
Sent: Monday, November 24, 2008 4:12 PM
To: oracle-l@xxxxxxxxxxxxx
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

 

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.


==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

Other related posts: