Re: Method for migrating schema from PROD to DEV
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: JEREMY.SHEEHAN@xxxxxxx
- Date: Mon, 24 Nov 2008 19:33:56 -0500
You can issue a 'drop table <tablename> cascade constraints;' and then not
worry about the constraint orders.
I know I have an anonymous PL/SQLscript I wrote a while ago to clear a
schema (excluding some objects like database links).
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone
else do a first-class job under your
direction."
-- William Feather
On Mon, Nov 24, 2008 at 4:31 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx>wrote:
> I started on the route of just dropping objects, but I came across some
> constraint issues. I know that I could get around it by dropping the tables
> in a particular sequence, but I'm in kind of a rush. I thought that just
> dropping the user and cascading it's objects it would work just as well.
>
>
>
> I didn't think about the TS Quotas. I'll be sure to keep that in mind
> before I migrate this. I'll just recreate the user as best as I can, then
> rerun any grants/privs that were missed due to missing objects.
>
>
>
> Thanks!
>
>
>
> Jeremy
>
> P *Consider the environment. Please don't print this e-mail unless you
> really need to.*
>
>
>
> *From:* Baumgartel, Paul [mailto:paul.baumgartel@xxxxxxxxxxxxxxxxx]
> *Sent:* Monday, November 24, 2008 4:27 PM
> *To:* SHEEHAN, JEREMY; oracle-l@xxxxxxxxxxxxx
> *Subject:* 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:
