RE: [Q] import several users at same time ????
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Feb 2006 10:56:15 -0500
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 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l