This discussion is archived
0 Replies Latest reply: Mar 15, 2013 9:58 AM by David Pulliam RSS

Migrating a Database that has APEX installed from 10gR2 to 11gR2 with imp

David Pulliam Explorer
Currently Being Moderated
What is the proper way to move and repair a database with APEX installed in it so that APEX will work again if you have absolutely no choice but to use imp and exp to do the move. In our case our 10g system is on Solaris SPARC 64 hardware and our new instance is on RHEL 5.9 VMs so just moving the files is out due to endian conversion and upgrading on Solaris is is not an option either as we are removing our Solaris hardware from contract. I am seeing my APEX instance convert but then after I run @apexins.sql to fix broken packages only a subset of my workspaces was visable in APEX on the new server and in some cases none of my workspaces existed at all.

Edited by: David Pulliam on Mar 15, 2013 12:58 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points