Re: Method for migrating schema from PROD to DEV
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: JEREMY.SHEEHAN@xxxxxxx
- 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.
Finn
On Mon, Nov 24, 2008 at 4:31 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx>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.
>
Other related posts:
