Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is Remote Import in Oracle Possible?
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 Received on Sun May 28 2006 - 05:42:06 CDT