{"id":7381,"date":"2020-11-04T16:44:01","date_gmt":"2020-11-04T16:44:01","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/how-to-take-apex-backups\/"},"modified":"2026-11-03T19:28:38","modified_gmt":"2026-11-03T19:28:38","slug":"how-to-take-apex-backups","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/how-to-take-apex-backups\/","title":{"rendered":"How to take APEX backups"},"content":{"rendered":"<p>\n<em>This post describes how to back up Oracle<\/em>\u00ae<em> Application Express (APEX).&nbsp;<\/em><\/p>\n<p><strong>APEX organization<\/strong><\/p>\n<p>Oracle organizes the APEX working area into workspaces that are associated with one or more Oracle database schemas. You should install APEX on the database that the applications use to access data and then create applications in workspaces. Following are more APEX organization facts:<\/p>\n<ul>\n<li>All workspaces and applications have a unique id assigned to them and are easy to track.&nbsp;<\/li>\n<li>Both workspaces and applications can have external files attached to them, such as CSS, JavaScript, images, and so on.&nbsp;<\/li>\n<li>Any application in the same workspace can access files attached to a workspace, but only&nbsp;an application can access files attached to that application.&nbsp;<\/li>\n<li>Metadata tables store information about workspaces, applications, and files.<\/li>\n<li>Your exported backup should include all the metadata on workspaces and applications.<\/li>\n<\/ul>\n<p><strong>What is APEX?&nbsp;<\/strong><\/p>\n<p>APEX is an enterprise low-code development platform where developers develop and deploy&nbsp;their applications to solve problems and provide immediate value. It is a free feature of&nbsp;Oracle Database.<\/p>\n<p>APEX has two components: a metadata repository and the APEX engine. The metadata repository&nbsp;stores all the application definitions, and the engine renders and processes all the&nbsp;application pages. APEX is stored within the Oracle database in the form of data tables and&nbsp;PL\/SQL scripts.<\/p>\n<p><strong>Backups<\/strong><\/p>\n<p><strong>According to <a href=\"https:\/\/www.netapp.com\/data-protection\/backup-recovery\/what-is-backup-recovery\/\">one source<\/a>,&nbsp;<\/strong>&#8220;The purpose of the backup is to create a copy of data that can be recovered in the event<br \/>\nof a primary data failure. Primary data failures can be the result of hardware or software&nbsp;failure, data corruption, or a human-caused event, such as a malicious attack (virus or&nbsp;malware), or accidental deletion of data. Backup copies allow data to be restored from an&nbsp;earlier point in time to help the business recover from an unplanned event.&#8221;<\/p>\n<p><strong>The APEX backup process<\/strong><\/p>\n<p>The Application Express installation files, in <strong>$ORACLE_HOME\/apex\/utilities\/oracle\/apex<\/strong>,<br \/>\ninclude two utilities, <strong>APEXExport.class<\/strong>&nbsp;and <strong>APEXEportSplitter.class<\/strong>, which you can use to export your APEX applications.<\/p>\n<p><strong>Step 1: Preparation<\/strong><\/p>\n<p>To prepare for the backup, perform the following steps:<\/p>\n<p>1. To use APEXExport, install JDK version 1.5 or later.&nbsp;<br \/>\n2. Make sure the Oracle JDBC class libraries are in your CLASSPATH.<br \/>\n3. Download Oracle Database 11g Release 2 (11.2.0.4) JDBC Drivers (<strong>ojdbc5.jar<\/strong>)&nbsp;from <a href=\"https:\/\/www.oracle.com\/database\/technologies\/jdbcdriver-ucp-downloads.html\">here<\/a>&nbsp;and place the file in <strong>$ORACLE_HOME\/jdbc\/lib<\/strong><\/p>\n<p><strong>Step 2: Set the environment source file<\/strong><\/p>\n<p><em>1. Create or update **apex.env** with the following content:<br \/>\n&nbsp;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; export ORACLE_HOME=\/u02\/app\/oradi\/db\/tech_st\/12.1.0<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; export ORACLE_SID=TIGER<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; export PATH=$PATH:$ORACLE_HOME\/bin<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; export CLASSPATH=.:${ORACLE_HOME}\/jdbc\/lib\/ojdbc5.jar<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; export JAVA_HOME=$ORACLE_HOME\/jdk\/<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; export PATH=$ORACLE_HOME\/jdk\/bin:$PATH<\/em><\/p>\n<p>2. Source the environment file, <strong>apex.env<\/strong>.<\/p>\n<p><strong>Step 3: Find your workspace ID<\/strong><\/p>\n<p>Use the workspace ID to take the export. Use the following database queries to retrieve<br \/>\nthe workspace ID information:<br \/>\n&nbsp;<br \/>\n<em>SQL&gt; select workspace_id,workspace,schemas from apex_workspaces;<br \/>\n&nbsp;<br \/>\n&nbsp; &nbsp; WORKSPACE_ID &nbsp; &nbsp; WORKSPACE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCHEMAS<br \/>\n&nbsp; &nbsp; &#8212;&#8212;&#8212;&#8212; &nbsp; &nbsp; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &nbsp; &#8212;&#8212;&#8212;-<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; INTERNAL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp; COM.ORACLE.APEX.REPOSITORY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; &nbsp; COM.ORACLE.CUST.REPOSITORY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br \/>\n&nbsp;<br \/>\n&nbsp; &nbsp; SQL&gt; set lines 200<br \/>\n&nbsp; &nbsp; SQL&gt;col WORKSPACE for a30<br \/>\n&nbsp; &nbsp; SQL&gt;col APPLICATION_NAME for a60<br \/>\n&nbsp; &nbsp; SQL&gt;col OWNER for a15<br \/>\n&nbsp; &nbsp; SQL&gt;select workspace,workspace_id,application_id,application_name,owner from apex_applications;<\/em><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26404-body-Picture1_21.png\" alt=\"APEX Pic 1\" \/><\/p>\n<p>&nbsp;<a href=\"https:\/\/docs.oracle.com\/cd\/E14373_01\/apirefs.32\/e13369\/apex_app.htm#AEAPI214\">Source<\/a><\/p>\n<p><strong>Step 4: Take the backup<\/strong><\/p>\n<p>Perform the following steps to take the backup:<\/p>\n<p>1. From the <strong>apex\/utility<\/strong>&nbsp;directory, issue the command for the export backup.<br \/>\n&nbsp;<br \/>\n2. Run the following command to go to the APEXExport class directory:<br \/>\n&nbsp;<br \/>\n<em>&nbsp; &nbsp; &nbsp; &nbsp; cd \/u02\/app\/oradi\/db\/tech_st\/12.1.0\/apex\/utilities\/oracle\/apex<\/em><br \/>\n&nbsp;<br \/>\n3. Run the following command to export all workspace backups:<br \/>\n&nbsp;<br \/>\n<em>&nbsp; &nbsp; &nbsp; &nbsp; \/u02\/app\/oradi\/db\/tech_st\/12.1.0\/jdk\/bin\/java oracle.apex.APEXExport -db nchphysicdb01.earth.com:1521:TIGER -user APEX_190200 -password $Apex_password -expWorkspace &gt; apex_workspace.log<\/em><br \/>\n&nbsp;<br \/>\n4. The log file should look similar to the following example:<br \/>\n&nbsp;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; Exporting Workspace 12:&#8217;COM.ORACLE.CUST.REPOSITORY&#8217;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Completed at Tue May 26 06:08:06 EST 2020<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; Exporting Workspace 1502512746446669:&#8217;GJE TEST&#8217;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Completed at Tue May 26 06:08:07 EST 2020<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; Exporting Workspace 1509724465613146:&#8217;NS-TEST&#8217;<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Completed at Tue May 26 06:08:07 EST 2020<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; -rw-rw-r&#8211; 1 oradi oradi 4.3K May 26 06:08 w12.sql &nbsp;&#8212;&#8211; exported backup apex workspace file<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; -rw-rw-r&#8211; 1 oradi oradi 7.0K May 26 06:08 w1502512746446669.sql &#8211; exported backup apex workspace file<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; -rw-rw-r&#8211; 1 oradi oradi 11K May 26 06:08 w1509724465613146.sql &#8211; exported backup apex workspace file<br \/>\n&nbsp;<br \/>\n<strong>APEX Export utility options<\/strong><br \/>\n&nbsp;<br \/>\nFollowing are the export options for APEX Export utility:<br \/>\n&nbsp;&nbsp;<br \/>\n&#8211; <strong>db<\/strong>: Database connect URL in JDBC format<br \/>\n&#8211; <strong>user<\/strong>: Database username<br \/>\n&#8211; <strong>password<\/strong>: Database password<br \/>\n&#8211; <strong>applicationid<\/strong>: ID for the exported application<br \/>\n&#8211; <strong>workspaceid<\/strong>: Workspace ID for all &nbsp;exported applications or the exported workspace<br \/>\n&#8211; <strong>expFiles<\/strong>: Export all workspace files identified by -workspaceid<br \/>\n&#8211; <strong>instance<\/strong>: Export all applications<br \/>\n&#8211; <strong>expWorkspace<\/strong>: Export workspace identified by -workspaceid or all workspaces if -workspaceid not specified<br \/>\n&#8211; <strong>skipExportDate<\/strong>: Exclude export date fr0om application export files<br \/>\n&#8211; <strong>expPubReport<\/strong>: Export all user saved public interactive reports<br \/>\n&#8211; <strong>expSavedReports<\/strong>: Export all user saved interactive reports<br \/>\n&#8211; <strong>expIRNotif<\/strong>: Export all interactive report notifications<br \/>\n&#8211; <strong>expTranslations<\/strong>: Export the translation mappings and all text from the translation repository<br \/>\n&#8211; <strong>expFeedback<\/strong>: Export team development feedback for all workspaces or identified by -workspaceid to development or deployment<br \/>\n&#8211; <strong>expTeamdevdata<\/strong>: Export team development data for all workspaces or identified by -workspaceid<br \/>\n&#8211; <strong>deploymentSystem<\/strong>: Deployment system for exported feedback<br \/>\n&#8211; <strong>expFeedbackSince<\/strong>: Export team development feedback since the specified date in the format `YYYYMMDD`<\/p>\n<p><strong>&nbsp;Example commands &#8211; The following are some export examples:<\/strong><\/p>\n<p><strong>Single application example<\/strong><\/p>\n<p><em>APEXExport -db localhost:1521:ORCL -user scott -password scotts_password -applicationid 31500<\/em><\/p>\n<p><strong>All applications in a workspace example<\/strong><\/p>\n<p><em>APEXExport -db localhost:1521:ORCL -user scott -password scotts_password -workspaceid 9999<\/em><\/p>\n<p><strong>All applications in an instance example<\/strong><\/p>\n<p><em>&nbsp; &nbsp; &nbsp; &nbsp;APEXExport -db localhost:1521:ORCL -user system -password systems_password -instance<br \/>\n&nbsp;<\/em><br \/>\n<strong>All workspaces example<\/strong><\/p>\n<p><em>&nbsp; &nbsp; &nbsp; &nbsp;APEXExport -db localhost:1521:ORCL -user system -password systems_password -expWorkspace<br \/>\n&nbsp;<\/em><br \/>\n<strong>Export feedback to development environment example<\/strong><\/p>\n<p><em>&nbsp; &nbsp; &nbsp; &nbsp;APEXExport -db localhost:1521:ORCL -user scott -password scotts_password -workspaceid 9999 -expFeedback<br \/>\n&nbsp;<\/em><br \/>\n<strong>Export feedback to deployment environment EA2 since 20100308 example<\/strong><\/p>\n<p><em>&nbsp; &nbsp; &nbsp; &nbsp;APEXExport -db localhost:1521:ORCL -user scott -password scotts_password -workspaceid 9999 -expFeedback -deploymentSystem EA2 -expFeedbackSince 20100308<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>Oracle APEX is a rapid web application development tool for the Oracle database. It helps you to quickly develop and deploy professional applications that are secure by using a web&nbsp;browser. You don&#8217;t need strong programming skills and can use different export options to&nbsp;take backups as needed. &nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to take APEX backups<\/p>\n","protected":false},"author":2,"featured_media":7383,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26404","content_type":"blog","created_by":"10130","authored_on":"2023-12-19T16:44:01+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rackspace Technology Staff","seo_description":"Step-by-step guide to creating efficient backups for Oracle Application Express (APEX), ensuring secure and resilient application performance.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26404-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2020-11-04T16:44:01","rxt_solutions":"Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"APEX Backups | Rackspace Technology","field_topics":"","field_slug":"how-to-take-apex-backups","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7381","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7381"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7381\/revisions"}],"predecessor-version":[{"id":9425,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7381\/revisions\/9425"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7383"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}