RE: import fromuser=scott touser=usera,userb
- From: "Mahadevan, Sundar" <Sundar.Mahadevan@xxxxxxx>
- To: "ballester.david@xxxxxxxxx" <ballester.david@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 6 Jul 2010 13:40:17 -0400
Hi All,
Thanks for all the responses. I have used fromuser=scott,tiger
touser=usera,userb before and hence was expecting fromuser=scott
touser=usera,userb to work. I did try David's suggestion of
fromuser=scott,scott touser=usera,userb. Import from scott -> usera succeeds
while scott->userb fails with the following error: IMP-00034: Warning: FromUser
"SCOTT" not found in export file. Import terminated successfully with warnings
--Sundar
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of David Ballester
Sent: July 6, 2010 12:25 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Re: import fromuser=scott touser=usera,userb
2010/7/6 D'Hooge Freek <Freek.DHooge@xxxxxxxxx<mailto:Freek.DHooge@xxxxxxxxx>>
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<mailto:freek.dhooge@xxxxxxxxx>
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer<http://www.uptime.be/disclaimer>
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto: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<mailto: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
Question that i never tried
what if
fromuser=scott,scott touser=usera,userb?
I think that imp reads sequentially and this should not work, but just curious
and no database for testing right now. Anyone tried before?
D.
Other related posts:
