| 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
![]()  | 
![]()  |