I have one prod server (184.108.40.206.0) servers on Windows 2003 R2 64 bit.
Server Name (PRODDB)
I do not have access to that prod server , i want to take one export data pump from my client machine and due to space issue in prod server , i want to keep dump file in my client machine itself. i can take traditional export and keep the dump file in my client machine but i do not know how to achieve the same via data pump ...
Can somebody guide me how to generate dump file in client machine itself via data pump ?
Thanks & Regards,
expdp puts the file on the database server. So, if you have no space on the database server, you have 3 options that I can think of:
1). Mount some remote storage such that's it's visible to the database server, create a directory object pointing there, and expdp to that storage
2). Use exp (which I don't like to suggest, but if you have to get the file on a client machine - this would do it)
3). Get some more space added to the prod server and get access to it
I thought I was clear on that: NO, not directly
If you were able to somehow mount some storage from your client machine on the server, then you could do it indirectly. Oh wait, I said that too (option 1)
THose of you who are suggesting to use a network link...
This is for exporting from one database to another database without going through the intermediate file. It will NOT create an export file. It will NOT create a file on the client. It does NOT answer the OP's question
Hi Niket ,
As per John's Post ..
who are suggesting to use a network link...
This is for exporting from one database to another database without going through the intermediate file. It will NOT create an export file. It will NOT create a file on the client.
So does it mean we can not create dump file in client machine using Data pump ?
Thanks & Regards,
This is the third time I've said it, so time to shout:
EXPDP CREATES ITS FILES ON THE SERVER, NOT THE CLIENT.
THE ONLY WAY TO HAVE IT CREATED ON THE CLIENT WOULD BE IF YOU CAN SOMEHOW MOUNT THE STORAGE FROM YOUR CLIENT ON THE SERVER.
I CANNOT BE ANY CLEARER THAN THAT... THE FILE IS ON THE SERVER. THE SERVER. THE SERVER. NOT THE CLIENT.
I HOPE YOU CAN HEAR ME, THE LINE SEEMS TO BE REALLY BAD TODAY FOR SOME REASON.