Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] import several users at same time????
"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