Re: Is Remote Import in Oracle Possible?

On 28 May 2006 03:42:06 -0700, "Milind" <milindkanetkar_at_gmail.com> wrote:

>Is it possible to import into Oracle using a remote media / harddisk.
>
>My requirement:
>
>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?
>
>Milind

1 Why didn't you try?
2 IIRC Oracle has never supported UNC, and you will need to set up a share and connect to that
3 It will be so dead slow, that buying a disk would be cheaper.

--
Sybrand Bakker, Senior Oracle DBA