Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is Remote Import in Oracle Possible?
> Have Oracle 9i on my laptop with a Schema of around 11 GB which I need
> to drop and import the updated copy of Schema which is around 12 GB. I
> have taken the 12 GB export dump from my production server and now want
> it to be imported on my laptop for testing / training etc etc.
>
> I do not have more than 7 GB of harddisk left on my laptop, but have
> the dump on a PC over the network. Possible to use this network address
> / path to import. DOS I don't think will recognise something like this
> - imp user/password_at_db file=\\PC\Oracle\prod.dmp ......
>
> Any ideas?
Open OracleNet port on your PC if needed and run the import from prod server:
imp user/pass_at_your_pc_instance file=dmp_on_prod_server ...
Regards
Dimitre
Received on Sun May 28 2006 - 06:59:08 CDT