Re: Method for migrating schema from PROD to DEV

From: Finn Jorgensen <>
Date: Mon, 24 Nov 2008 17:12:27 -0500
Message-ID: <>

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

Received on Mon Nov 24 2008 - 16:12:27 CST

Original text of this message