Re: import fromuser=scott touser=usera,userb
- From: David Ballester <ballester.david@xxxxxxxxx>
- To: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 6 Jul 2010 18:24:35 +0200
2010/7/6 D'Hooge Freek <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
> 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
>
>
>
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:
