Re: Exporting / Importing Database Users

From: <jtesta_at_my-dejanews.com>
Date: Fri, 07 Aug 1998 12:52:30 GMT
Message-ID: <6qetae$okf$1@nnrp1.dejanews.com>

You just want to export the users, how about using sql to build sql instead.

like this:
 select 'create user '||username||

   ' identified by values '||''''||password||''''||
   ' default tablespace '||default_tablespace||
   ' temporary tablespace '|| temporary_tablespace||';' from

   sys.dba_users;

This does NOT do grants, quotas, etc, but its a starting point for you to build on.

you do a spool on BEFORE running this and a spool off AFTER.

then all u have to do is @spoolfilename

hth, joe
http://www.oracle-dba.com

In article <6qdchh$9n3$1_at_flint.sentex.net>,   "Dennis R. Leon" <dleon_at_rim.net> wrote:
> I'm trying to export all the users from one database and then importing them
> to a brand new database.
>
> Everything I tried failed!!!
>
> Does anybody know how this can be done? (I'm new at this!)
>
> Your help would be greatly appreciated.
>
> ~~~~~~~~~~~~~~~~~~~
> Dennis R. Leon
> dleon_at_rim.net
>
> Research In Motion Ltd.
> http://www.rim.net/
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 07 1998 - 07:52:30 CDT