ONE LITTLE DOUBT :
You suggested to use "select dbms_metadata.get_ddl('ROLE',role) from
dba_roles " for ddl generation. I just wanted to know whats the difference
between your command and "select 'CREATE ROLE '||role||';' from dba_roles ;
" command as the output of both these commands are same.
On 9/27/05, Gogala, Mladen <MGogala_at_allegientsystems.com> wrote:
>
> select dbms_metadata.get_ddl('ROLE',role) from dba_roles
> should provide a collection for "CREATE ROLE" DDL statements.
>
> --
> Mladen Gogala
> Ext. 121
>
> -----Original Message-----
> From: Yechiel Adar [mailto:adar76_at_inter.net.il <adar76_at_inter.net.il>]
> Sent: Tuesday, September 27, 2005 9:41 AM
> To: ORACLE-L
> Subject: copt roles to another database
>
> Hello
>
> Oracle 9.2.0.5/6 <http://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
>
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 28 2005 - 00:16:32 CDT
