copt roles to another database

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Tue, 27 Sep 2005 15:41:18 +0200
Message-ID: <43394BFE.3060204@inter.net.il>

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 Received on Tue Sep 27 2005 - 07:44:09 CDT