copt roles to another database

From: Yechiel Adar <adar76@xxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 27 Sep 2005 15:41:18 +0200

Hello

Oracle 9.2.0.5/6 on windows.

I am developing a script to merge two databases together using transportable tablespaces (TTS) export/import. I need to create a script to copy roles from one database to another, so when I run the create users ddl it will work without problems.

How can I get a script to create the roles based on existing roles in the database. Dbms_metadata does not give option to create ddl for roles.

I searched the docs, Metalink and google without results.

TIA

--
Adar Yechiel
Rechovot, Israel


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: copt roles to another database
From: Kirtikumar Deshpande

copt roles to another database

Other related posts: