Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] import several users at same time????

Re: [Q] import several users at same time????

From: DR <dr_at_invalid.address>
Date: Thu, 16 Feb 2006 16:28:07 +0100
Message-ID: <43f49a05$0$15795$14726298@news.sunsite.dk>


"aaa" <aaa_member_at_newsguy.com> ha scritto nel messaggio news:dt24f6016hn_at_drn.newsguy.com...
> We have ORACLE 9ir2 on several servers. I need migrate several users from
> one
> database to another database. I have script which can import one user:
>
> file=file1.dmp
> buffer=64000000
> ignore=n
> grants=y
> indexes=y
> rows=y
> fromuser=user1
> touser=user1
> feedback=10000
> log=imp_user1.log
> commit=y
>
> is it possible I can import several users at same script?

Yes:

fromuser=user1, user2, user3
touser=user1, user2, user3

Regards,
Dimitre Received on Thu Feb 16 2006 - 09:28:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US