Skip to main content

Posts

Showing posts from November, 2011

Moving Workspaces from PC to PC

I had an urgent need to move loads of APEX workspaces and schemas in an Oracle XE installation from  a Windows PC(PC1) to another Windows PC(PC2) running windows 7 OS. Stated below are the steps i took after a successfully installation of Apex 4.0 on Oracle 10g XE on PC2 Stop listener and other processes on PC2 Rename the oraclexe home folder on PC2 Copy oraclexe home folder from PC1 to PC2 ensure you maintain existing path Ensure your new tnsnames.ora and listener.ora files contains PC2's host name Restart your listener and other processes Though this might not be best practice but it sure worked for me. Hope you find it helpful