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 ==============================================================================