Re: Method for migrating schema from PROD to DEV
From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Mon, 24 Nov 2008 17:12:27 -0500
Message-ID: <74f79c6b0811241412pa0d44bfn4cf9b07cc6c5accd@mail.gmail.com>
Date: Mon, 24 Nov 2008 17:12:27 -0500
Message-ID: <74f79c6b0811241412pa0d44bfn4cf9b07cc6c5accd@mail.gmail.com>
If you have TOAD it can give you the script to create the user just like it
is in production. Quick and easy.
Generally what's in the script is user w/def&temp tablespace, granted roles, granted sys privs, granted obj privs, tablespace quotas.
Finn
On Mon, Nov 24, 2008 at 4:31 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>wrote:
> 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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 24 2008 - 16:12:27 CST