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 
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: