Just had a big think about this. I have a dataguard primary with Apex and
standby with Apex on. The standby apex stuff works fine when I switch over.
With the exception of some of the connection info needing to be updated in
an xml file. As Dataguard replicates the database across two boxes - as you
can with Datapump then it sounds likely that datapump would work.
Howard A. Latham
On 5 June 2018 at 13:19, Scott Canaan <srcdco@xxxxxxx> wrote:
I have an application that uses Oracle Apex. We are just starting an
application, Oracle, and O/S upgrade. I have to copy the Apex “install”
from Oracle 220.127.116.11 on Red Hat 6 to Oracle 18.104.22.168 on Red Hat 7.
Normally, I do a data pump import across the network to migrate the Oracle
schemas, but I’ve been told that doesn’t work for Apex. I need to preserve
the Apex version at 4.01 until the application upgrade, then it will be
upgraded to the current version.
Is it true that I can’t use Oracle data pump to copy Apex from one server
*Scott Canaan ‘88*
*Sr Database Administrator *Information & Technology Services
Finance & Administration
*Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
srcdco@xxxxxxx | c: (585) 339-8659
*CONFIDENTIALITY NOTE*: The information transmitted, including
attachments, is intended only for the person(s) or entity to which it is
addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any
action in reliance upon this information by persons or entities other than
the intended recipient is prohibited. If you received this in error, please
contact the sender and destroy any copies of this information.