Home » RDBMS Server » Server Utilities » Exporting from Physical standby (Oracle 11.2.0.3 Redhat Linux)
Exporting from Physical standby [message #562685] Fri, 03 August 2012 07:05 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66722
Registered: March 2007
Location: Nanterre, France, http://...
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 #668592 is a reply to message #562687] Sun, 04 March 2018 15:59 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
Sorry Michel the solution which you mentioned does not work as it fails with SCN error.

Oracle metalink also say it works but practically it fails.If you don't believe please test yourself.
Re: Exporting from Physical standby [message #668593 is a reply to message #668592] Mon, 05 March 2018 12:12 Go to previous messageGo to next message
Michel Cadot
Messages: 66722
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

John Watson wrote on Wed, 28 December 2016 10:58
Come on, man. Are you trolling? Being deliberately stupid to make people angry? Or do you actually believe that anyone can assist with that amount of information?
Re: Exporting from Physical standby [message #668595 is a reply to message #668592] Tue, 06 March 2018 04:09 Go to previous message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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.
Previous Topic: Export/Import Unused column
Next Topic: SQL*Loader-350: Syntax error at line 9. Expecting "(" WHEN clause
Goto Forum:
  


Current Time: Wed Dec 11 14:22:15 CST 2019