Re: Method for migrating schema from PROD to DEV
Date: Mon, 24 Nov 2008 17:12:27 -0500
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.
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.