Skip to Main Content
  • Questions

  • how to restore application in my apex workspace

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, shaaban.

Asked: September 09, 2016 - 7:09 pm UTC

Last updated: May 04, 2022 - 3:24 pm UTC

Version: oracle 11g and apex 4.2.4

Viewed 10K+ times! This question is

You Asked

Hi

i have a workspace in oracle apex 4.2.2 the name is (calldetail) the worksapce contain 5 apllication(the appliaction id is 100,101,102,104,104) i backup it and then after 1 minut delete it i forget take backup from application but i get a full backup from database help me how to restor apex application ?

and Connor said...

Restore your database into a new area or host. Once the database is running, you can do a command line export of all of your apps, eg

C:\Users\comcdona>set ORACLE_HOME=C:\oracle\product\12.1.0.2

C:\Users\comcdona>set CLASSPATH=%CLASSPATH%;.\;%ORACLE_HOME%\jdbc\lib\ojdbc6.jar;C:\oracle\product\apex\utilities

C:\Users\comcdona>
C:\Users\comcdona>java oracle.apex.APEXExport -db localhost:1521:np12 -user system -password ******* -instance
Exporting Application 8801:'Theme: Simple Red'
  Completed at Sat Sep 10 08:57:04 AWST 2016
Exporting Application 8802:'Theme: Builder Blue'
  Completed at Sat Sep 10 08:57:05 AWST 2016
Exporting Application 8803:'Theme: Midnight Blue'
  Completed at Sat Sep 10 08:57:05 AWST 2016
Exporting Application 8804:'Theme: Topaz'
  Completed at Sat Sep 10 08:57:06 AWST 2016
Exporting Application 8805:'Theme: Sunrise'
  Completed at Sat Sep 10 08:57:06 AWST 2016
Exporting Application 8806:'Theme: Centered Blue'
  Completed at Sat Sep 10 08:57:07 AWST 2016
Exporting Application 8807:'Theme: Modern Blue'
  Completed at Sat Sep 10 08:57:07 AWST 2016
Exporting Application 8808:'Theme: Orange'
  Completed at Sat Sep 10 08:57:08 AWST 2016
Exporting Application 8809:'Theme: Simple Gray'
  Completed at Sat Sep 10 08:57:08 AWST 2016
Exporting Application 8810:'Theme: Sand'
  Completed at Sat Sep 10 08:57:09 AWST 2016
....


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.