From oracle-l-bounce@freelists.org Tue Sep 27 08:17:57 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8RDHvdv018508 for ; Tue, 27 Sep 2005 08:17:57 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8RDHp6H018478 for ; Tue, 27 Sep 2005 08:17:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA1821EF15F; Tue, 27 Sep 2005 08:17:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23435-02; Tue, 27 Sep 2005 08:17:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A9E51E0A9B; Tue, 27 Sep 2005 08:17:16 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=HTvjYk1HYL5u7ZOcD3x5zzaVoTogeOTBO9J2tLBaFwmgl1LckkIahvJJVrU+MJ8ncFFcgXXRBWngkuLiLu5yLMfSI4SDdjJ2ZCv+fb1vMtL6F7qA1BOpQgTcQNjNr5+Zk5nxjGab7cmS5uMNVKekXxCiij1njsqshIEY6fwVdHs= ; Message-ID: <20050927131512.65250.qmail@web50111.mail.yahoo.com> Date: Tue, 27 Sep 2005 06:15:12 -0700 (PDT) From: Kirtikumar Deshpande Subject: Re: copt roles to another database To: adar76@inter.net.il, ORACLE-L In-Reply-To: <43394BFE.3060204@inter.net.il> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 25930 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kedeshpande@yahoo.com Precedence: normal Reply-To: kedeshpande@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD autolearn=no version=2.63 How about creating the cr_roles.sql script from the source, and running it on the target before creating the users. set pages 0 feedback off spool cr_roles.sql select 'create role ' || role || ';' from dba_roles; spool off Cheers! - Kirti --- Yechiel Adar wrote: > 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 > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l