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

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 16 Feb 2006 10:56:15 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF680F9F@EXCNYSM0A1AJ.nysemail.nyenet>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Thursday, February 16, 2006 10:36 AM To: oracle-l_at_freelists.org
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 Received on Thu Feb 16 2006 - 09:56:15 CST