| Exporting from Physical standby [message #562685] |
Fri, 03 August 2012 07:05  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
I would like to export few tables from the physical standby which is in read only mode.
I have tried both the exp and expdp methods and could successfully export and import the tables from physical standby using exp unfortunately the expdp does not allow this process from a read only database.
Does this mean that we still have to use the exp feature instead of expdp ?
Note : I would expect a proper response from experts and no unwanted comments like "Contact Oracle support" or "Paste the entire command here" or "Read the Manuals" or "Why i am exporting from Standby and not from Primary" etc.
Thanks
|
|
|
|
| Re: Exporting from Physical standby [message #562687 is a reply to message #562685] |
Fri, 03 August 2012 07:39  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:Does this mean that we still have to use the exp feature instead of expdp ?
Expdp requires to create and write into a work table and so this is not possible on a standby database.
But you can create a database link in another database that points to the standby and then use expdp fromit using the network_link parameter.
Regards
Michel
[Updated on: Fri, 03 August 2012 07:40] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Exporting from Physical standby [message #668595 is a reply to message #668592] |
Tue, 06 March 2018 04:09 |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
|
Senior Member |
|
|
preet_kumar wrote on Sun, 04 March 2018 21:59
Oracle metalink also say it works but practically it fails.
Despite the caveat in your OP, you really do need to show us what you are doing.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
