Sundar, The command will import the objects from the scott schema in the dump file into the usera schema on the database. If you would have something like "fromuser=scott,tiger touser=usera,userb" then scott's objects will be imported into usera and tiger's objects into the userb schema. Regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer ________________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mahadevan, Sundar Sent: dinsdag 6 juli 2010 16:48 To: Oracle-L@xxxxxxxxxxxxx Subject: import fromuser=scott touser=usera,userb Hi All, Good morning. I am on Oracle 10.2.0.4.0 and the above command only imported usera and not userb. Is this how this is supposed to work? My understanding is scott's objects should have been imported into usera as well as userb. Thanks for all your help. --Sundar -- //www.freelists.org/webpage/oracle-l