RE: [Q] import several users at same time ????

From: <oracle-l-bounce_at_freelists.org>
Date: Thu, 16 Feb 2006 16:51:25 -0000
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F63030F1457@UKWMXM04>

Actually I read the question as "can you run multiple imports in parallel" to which the answer is yes but performance might be slow

However Tom's points still apply to that interpretation of the original post

John

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F (LABOR)
Sent: 16 February 2006 15:56
To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org Subject: RE: [Q] import several users at same time ????

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-----

????

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?

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

Received on Thu Feb 16 2006 - 10:51:25 CST