Doesn't anybody read the manuals anymore? Or try a test before asking a simple question? Sheesh! Set up a simple test with one table in two accounts and see what happens! It should take you all of 10 minutes! -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Thursday, February 16, 2006 10:36 AM To: oracle-l@xxxxxxxxxxxxx Subject: [Q] import several users at same time ???? 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? Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l