Re: Moving Users from on Ora DB to another

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 24 Aug 2001 09:13:44 +0100
Message-ID: <3b860cb8$0$238$ed9e5944@reading.news.pipex.net>

try spooling off the output of the following to a sql script.

select 'create user '||username||' identified by values '''||password||''' default tablespace '||default_tablespace||' temporary tablespace '||temporary_tablespace||';'
from dba_users
where username not in ('SYS','SYSTEM',<plus any others>);

You can do a similar thing with dba_role_privs for the roles for each user.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Lonnie L. Comer" <llc_at_phreaker.net> wrote in message
news:vIlh7.1971$9h1.19867_at_open-news.pacbell.net...


> I am trying to move all of the users from one instance to another.  I

don't


> want any of the data just the users and all objects.  I know that I can

use


> exp and specify my owner but I this is not a one time thing.  I am going

to


> be moving users from db to db quite often for testing.

>

> L|C

>

> "Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message

> news:3B858BCF.DB6F5F77_at_attws.com...

> > "Lonnie L. Comer" wrote:

> >

> > > Does anyone have any scripts that can move users from one instance to

> > > another?

> > >

> > > L|C

> >

> > What do you mean by "move users"?

> >

> > Daniel A. Morgan

> >

>

>

Received on Fri Aug 24 2001 - 03:13:44 CDT