Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is Remote Import in Oracle Possible?

Re: Is Remote Import in Oracle Possible?

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Sun, 28 May 2006 13:59:08 +0200
Message-ID: <4479908c$0$15785$14726298@news.sunsite.dk>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US