Re: Copying Users/Roles/Privs between Oracle Instances

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 3 Apr 2001 01:18:23 -0500
Message-ID: <9abpvf$keb$1@garnet.tc.umn.edu>

I have a cheezy AWK-KSH script that will copy DDL into a form that is executable by an interpreter.

It is located on http://www.sofbot.com/
the script is called ugly_DDL.ksh and uses exp and imp to get the DDL which has to be filtered to run in something like sqlplus.

Then take out the roles, users, grants, etc.

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.sofbot.com/


---------------------------------------------------------

Received on Tue Apr 03 2001 - 01:18:23 CDT