Oracle APEX comes preconfigured on Oracle Autonomous Database. Customers can follow this blog post to help them migrate their APEX applications to the Oracle Autonomous Data in Oracle Cloud. You need to copy your data, Workspace and Static Files, APEX applications, and RESTful services into your new cloud environment.
In this blog we continue Part 1 and we will be using Oracle SQL Developer Command-Line (SQLcl) tool. You need to download it. The version that has been tested is: 22.3.0.0
Note: This is a new version of a previous blog post by Joel Kallman.
Exporting your data
The first step is to export your data as a datapump file. To do so, you need to connect to your on-prem database:
PS C:\Apps\apex\apps_exports\sqlcl\bin> .\sql /nolog SQLcl: Release 22.3 Production on Mon Oct 03 11:21:12 2022 Copyright (c) 1982, 2022, Oracle. All rights reserved. SQL> connect shlayel/YOURPASSWORD@localhost:1521/APEX221 Connected.
View the Autonomous Database documentation to set the recommended settings for export.
exclude=cluster,indextype,db_link parallel=n schemas=schema_name dumpfile=export%u.dmp
Use dp export command from SQLcl to export your schema:
SQL> dp export -excludelist cluster,db_link -dumpfile export.dmp -parallel 2 -schemas SHLAYEL ** Datapump Command Start ** at 2022.10.01-01.32.14 Initiating DATA PUMP DATABASE TIME ZONE: VERSION:31 CON_ID:0 Log Location: DATA_PUMP_DIR:ESQL_19202.LOG Starting "SHLAYEL"."ESQL_19202": Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/IDENTITY_COLUMN Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT . . exported "SHLAYEL"."NYC_HIGHSCHOOLS" 154.7 KB 427 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_STOCKS" 115.9 KB 501 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_SAMPLE_DATA" 25.43 KB 309 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_TASKS" 20.05 KB 73 rows . . exported "SHLAYEL"."F1" 14.53 KB 22 rows . . exported "SHLAYEL"."F2" 14.53 KB 22 rows . . exported "SHLAYEL"."FORMULA1" 14.53 KB 22 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_POPULATION" 12.68 KB 51 rows . . exported "SHLAYEL"."ONBOARDINGS" 12.58 KB 5 rows . . exported "SHLAYEL"."WATCHLIST" 11.28 KB 4 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_STATS" 10.88 KB 22 rows . . exported "SHLAYEL"."EBA_DEMO_APPR_SAL_HISTORY" 10.81 KB 161 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_ORDERS" 9.953 KB 20 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_BBALL" 9.210 KB 10 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_GRADES" 8.820 KB 15 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_PROJECTS" 8.656 KB 14 rows . . exported "SHLAYEL"."EBA_DEMO_APPR_EMP" 8.703 KB 14 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_EMP" 8.789 KB 14 rows . . exported "SHLAYEL"."EMP" 8.781 KB 14 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_PRODUCTS" 8.554 KB 5 rows . . exported "SHLAYEL"."EXPENSES" 8.351 KB 5 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_SAMPLES" 8.398 KB 100 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_SAMPLE_NAMES" 7.765 KB 5 rows . . exported "SHLAYEL"."EBA_DEMO_APPR_APPROVERS" 7.460 KB 5 rows . . exported "SHLAYEL"."MOVIE_USERS" 7.25 KB 1 rows . . exported "SHLAYEL"."DEPT" 6.031 KB 4 rows . . exported "SHLAYEL"."EBA_DEMO_APPR_DEPT" 6 KB 4 rows . . exported "SHLAYEL"."EBA_DEMO_CHART_DEPT" 6.046 KB 4 rows . . exported "SHLAYEL"."EMAIL_SETTINGS" 5.585 KB 3 rows . . exported "SHLAYEL"."FORMULA" 0 KB 0 rows . . exported "SHLAYEL"."REQUISITIONS" 0 KB 0 rows Master table "SHLAYEL"."ESQL_19202" successfully loaded/unloaded ****************************************************************************** Dump file set for SHLAYEL.ESQL_19202 is: /opt/oracle/admin/devenv/dpdump/DC05E9B31DC23A10E0530100007FF70E/export.dmp Job "SHLAYEL"."ESQL_19202" successfully completed at Fri Sep 30 21:33:33 2022 elapsed 0 00:01:12 DataPump Operation Status 'COMPLETED' Jobname = ESQL_19202 ** Datapump Command End ** at 2022.10.01-01.33.35
Exporting Your APEX Applications and Workspace
Now that you have your datapump ready, you need to export your Workspace, Workspace Static Files, and APEX applications.
But first, you need to get the Workspace ID.
Sign in to your on-premises Workspace that you would like to migrate.
Click the ? icon in the upper right, choose About and then copy your Workspace ID.
Use apex export command to export your Workspace. This command exports all relevant Workspace metadata, including groups, group grants, users, RESTful services, user interface defaults, attribute dictionary, and so on.
SQL> apex export -expWorkspace -workspaceId 1844639310557765 Exporting Workspace 1844639310557765:'SHLAYEL' File w1844639310557765.sql created
Next, export your Workspace Static Files using the -expFiles attribute:
SQL> apex export -expFiles -workspaceid 1844639310557765 File files_1844639310557765.sql created
Finally, you can export all the applications under your Workspace using -workspace attribute:
SQL> apex export -workspaceid 1844639310557765 Exporting Application 109:'f2' File f109.sql created Exporting Application 107:'NYC Highschools' File f107.sql created Exporting Application 108:'Movie Watchlist' File f108.sql created Exporting Application 106:'Quick Projects' File f106.sql created Exporting Application 113:'Formula' File f113.sql created Exporting Application 111:'F2' File f111.sql created Exporting Application 114:'Formula1' File f114.sql created Exporting Application 104:'F1' File f104.sql created Exporting Application 100:'Sample Charts' File f100.sql created Exporting Application 110:'EmployeeOnboarding' File f110.sql created
We now have the datapump that includes the schema and its data, the Workspace and Workspace Static Files, and the APEX Applications under our Workspace.
Generate Auth Token
-
Log in to your Oracle Cloud Console using your OCI account.
-
Obtain your OCI token by clicking the user icon in the upper right corner and choosing User Settings.
-
Under Resources, click Auth tokens. If you do not already have an Auth Token, click the Generate Token button.
-
Copy the token which you will use in a later step.
Create Bucket
-
Navigate to Object Storage by clicking the icon on the home page or using the upper left hamburger menu, go to Storage => Object Storage & Archive Storage
- Pick a compartment and an existing bucket, or create a new bucket (e.g. export)
- Click on the bucket you just created and save the Object Storage Namespace to use in a later step
Download Wallet
To connect to Autonomous Database from your machine, you need to download the Database Wallet.
- Log in to Autonomous Transaction Processing or Autonomous Data Warehouse
- Click Database Connection
- Click Download wallet and save the zip file
Connect to Autonomous Database
Go back to your SQLcl and set the path to the wallet you saved in the previous step.
Use the connect command to connect to your Autonomous Database:
SQL> set cloudconfig C:\Apps\apex\apps_exports\Wallet_export.zip SQL> connect admin/YOURADMINPASSWORD@YOURDATABASENAME_high Connected.
Transfer Datapump to Object Storage
Under your Autonomous Database, you need to create a Database Credential using the Auth Token.
SQL> BEGIN 2 DBMS_CLOUD.CREATE_CREDENTIAL( 3 credential_name => 'MYCRED', 4 username => 'YOUR_USERNAME', 5 password => 'AUTH_TOKEN'); 6 END; 7* / PL/SQL procedure successfully completed.
Replace YOUR_USERNAME with the user you see once you click on the Profile icon and AUTH_TOKEN with the token value you saved earlier.
Now we can set the Cloud Storage using the CS tool from your SQLcl. You will be able to transfer the Datapump file from your machine to the Object Storage using the put command.
SQL> CS https://objectstorage.us-ashburn-1.oraclecloud.com/n/OBJECT_STORAGE_NAMESPACE/b/export DBMS_CLOUD Credential: Not Set OCI Profile: Not Set Transfer Method: Not set URI as specified: https://objectstorage.us-ashburn-1.oraclecloud.com/n/OBJECT_STORAGE_NAMESPACE/b/export
Replace OBJECT_STORAGE_NAME with the Object Storage Name you saved during Create Bucket step.
Set the credential to MYCRED credential:
SQL> dbcc mycred DBMS_CLOUD Credential: MYCRED OCI Profile: Not Set Transfer Method: dbms_cloud URI as specified: https://objectstorage.us-ashburn-1.oraclecloud.com/n/OBJECT_STORAGE_NAMESPACE/b/export
Now that you have set the right credential, you can initiate the transfer of the Datapump from your machine to the Object Storage of your Oracle Cloud:
SQL> cs put ./export.dmp /o/export.dmp Put ./export.dmp copied to https://objectstorage.us-ashburn-1.oraclecloud.com/n/OBJECT_STORAGE_NAMESPACE/b/export/o/export.dmp SQL> cs listo export.dmp 2048000
Import Data
Before importing your export.dmp file, you will need to determine the tablespace name which you will use to remap to the default DATA tablespace. Run the following query on the database instance you are migrating from. Replace ‘SHLAYEL’ below with the schema associated with the workspace you are migrating.
select default_tablespace from sys.dba_users where username = 'SHLAYEL';
You are ready now to import your Datapump file.
- You will create a STAGING database directory to save the log file
- Create a schema with the same name you had on-premises
- Grant the new schema quota on the DATA tablespace
SQL> CREATE or replace DIRECTORY staging AS 'stage'; Directory STAGING created. SQL> create user shlayel identified by YOUR_PASSWORD; User SHLAYEL created. SQL> ALTER USER shlayel QUOTA 128M ON data; User SHLAYEL altered. SQL> dp import -schemas SHLAYEL -dumpuri /o/export.dmp -c mycred -rt SYSTEM=DATA -directory staging -logfile emp.log Initiating DATA PUMP DATABASE TIME ZONE: VERSION:38 CON_ID:0 Log Location: STAGING:emp.log Master table "ADMIN"."ISQL_222" successfully loaded/unloaded Starting "ADMIN"."ISQL_222": Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "SHLAYEL"."ESQL_19202" 1.162 MB 1693 rows . . imported "SHLAYEL"."NYC_HIGHSCHOOLS" 154.7 KB 427 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_STOCKS" 115.9 KB 501 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_SAMPLE_DATA" 25.43 KB 309 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_TASKS" 20.05 KB 73 rows . . imported "SHLAYEL"."F1" 14.53 KB 22 rows . . imported "SHLAYEL"."F2" 14.53 KB 22 rows . . imported "SHLAYEL"."FORMULA1" 14.53 KB 22 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_POPULATION" 12.68 KB 51 rows . . imported "SHLAYEL"."ONBOARDINGS" 12.58 KB 5 rows . . imported "SHLAYEL"."WATCHLIST" 11.28 KB 4 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_STATS" 10.88 KB 22 rows . . imported "SHLAYEL"."EBA_DEMO_APPR_SAL_HISTORY" 10.81 KB 161 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_ORDERS" 9.953 KB 20 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_BBALL" 9.210 KB 10 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_GRADES" 8.820 KB 15 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_PROJECTS" 8.656 KB 14 rows . . imported "SHLAYEL"."EBA_DEMO_APPR_EMP" 8.703 KB 14 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_EMP" 8.789 KB 14 rows . . imported "SHLAYEL"."EMP" 8.781 KB 14 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_PRODUCTS" 8.554 KB 5 rows . . imported "SHLAYEL"."EXPENSES" 8.351 KB 5 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_SAMPLES" 8.398 KB 100 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_SAMPLE_NAMES" 7.765 KB 5 rows . . imported "SHLAYEL"."EBA_DEMO_APPR_APPROVERS" 7.460 KB 5 rows . . imported "SHLAYEL"."MOVIE_USERS" 7.25 KB 1 rows . . imported "SHLAYEL"."DEPT" 6.031 KB 4 rows . . imported "SHLAYEL"."EBA_DEMO_APPR_DEPT" 6 KB 4 rows . . imported "SHLAYEL"."EBA_DEMO_CHART_DEPT" 6.046 KB 4 rows . . imported "SHLAYEL"."EMAIL_SETTINGS" 5.585 KB 3 rows . . imported "SHLAYEL"."FORMULA" 0 KB 0 rows . . imported "SHLAYEL"."REQUISITIONS" 0 KB 0 rows Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/IDENTITY_COLUMN Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Job "ADMIN"."ISQL_222" successfully completed at Mon Oct 3 20:15:18 2022 elapsed 0 00:01:58 DataPump Operation Status 'COMPLETED' Jobname = ISQL_222
Note the -c mycred attribute which will use the same DBMS_CLOUD credential that we created earlier.
Import APEX Workspace and Applications
Without leaving SQLcl, you can now run the Workspace, Workspace Static Files, and APEX Applications script files you exported earlier.
Repeat the step for each application you would like to import. This step can be enhanced by scripting to automate importing multiple applications at once.
SQL> @w1844639310557765.sql --application/set_environment WORKSPACE 1844639310557765 Creating workspace SHLAYEL... Creating Groups... Creating group grants... Creating Users... ...RESTful Services SCHEMA SHLAYEL - User Interface Defaults, Table Defaults User Interface Defaults, Attribute Dictionary ...done SQL> @files_1844639310557765.sql --application/set_environment ...done SQL> @f104.sql --application/set_environment APPLICATION 104 - F1 --application/delete_application --application/create_application --application/shared_components/workflow/task_definitions/title_changed --application/shared_components/navigation/lists/navigation_menu --application/shared_components/navigation/lists/navigation_bar --application/shared_components/navigation/lists/page_navigation --application/shared_components/navigation/lists/access_control --application/shared_components/files/icons_app_icon_32_png --application/shared_components/files/icons_app_icon_192_png --application/shared_components/files/icons_app_icon_512_png --application/plugin_settings --application/shared_components/security/authorizations/administration_rights --application/shared_components/security/authorizations/contribution_rights --application/shared_components/security/authorizations/reader_rights --application/shared_components/security/app_access_control/administrator --application/shared_components/security/app_access_control/contributor --application/shared_components/security/app_access_control/reader --application/shared_components/navigation/navigation_bar --application/shared_components/logic/application_settings --application/shared_components/navigation/tabs/standard --application/shared_components/navigation/tabs/parent --application/shared_components/user_interface/lovs/access_roles --application/shared_components/user_interface/lovs/email_username_format --application/shared_components/user_interface/lovs/unified_task_list_lov_due --application/shared_components/user_interface/lovs/unified_task_list_lov_initiated --application/shared_components/user_interface/lovs/unified_task_list_lov_priority --application/shared_components/user_interface/lovs/unified_task_list_lov_state --application/pages/page_groups --application/shared_components/navigation/breadcrumbs/breadcrumb --application/shared_components/navigation/breadcrumbentry --application/shared_components/user_interface/templates/page/drawer --application/shared_components/user_interface/templates/page/master_detail --application/shared_components/user_interface/templates/page/modal_dialog --application/shared_components/user_interface/templates/page/login --application/shared_components/user_interface/templates/page/wizard_modal_dialog --application/shared_components/user_interface/templates/page/left_side_column --application/shared_components/user_interface/templates/page/right_side_column --application/shared_components/user_interface/templates/page/left_and_right_side_columns --application/shared_components/user_interface/templates/page/minimal_no_navigation --application/shared_components/user_interface/templates/page/standard --application/shared_components/user_interface/templates/button/icon --application/shared_components/user_interface/templates/button/text --application/shared_components/user_interface/templates/button/text_with_icon --application/shared_components/user_interface/templates/region/alert --application/shared_components/user_interface/templates/region/blank_with_attributes --application/shared_components/user_interface/templates/region/blank_with_attributes_no_grid --application/shared_components/user_interface/templates/region/buttons_container --application/shared_components/user_interface/templates/region/cards_container --application/shared_components/user_interface/templates/region/carousel_container --application/shared_components/user_interface/templates/region/collapsible --application/shared_components/user_interface/templates/region/content_block --application/shared_components/user_interface/templates/region/hero --application/shared_components/user_interface/templates/region/image --application/shared_components/user_interface/templates/region/inline_dialog --application/shared_components/user_interface/templates/region/inline_drawer --application/shared_components/user_interface/templates/region/inline_popup --application/shared_components/user_interface/templates/region/interactive_report --application/shared_components/user_interface/templates/region/login --application/shared_components/user_interface/templates/region/standard --application/shared_components/user_interface/templates/region/tabs_container --application/shared_components/user_interface/templates/region/title_bar --application/shared_components/user_interface/templates/region/wizard_container --application/shared_components/user_interface/templates/list/top_navigation_tabs --application/shared_components/user_interface/templates/list/top_navigation_mega_menu --application/shared_components/user_interface/templates/list/wizard_progress --application/shared_components/user_interface/templates/list/menu_bar --application/shared_components/user_interface/templates/list/badge_list --application/shared_components/user_interface/templates/list/media_list --application/shared_components/user_interface/templates/list/side_navigation_menu --application/shared_components/user_interface/templates/list/top_navigation_menu --application/shared_components/user_interface/templates/list/navigation_bar --application/shared_components/user_interface/templates/list/cards --application/shared_components/user_interface/templates/list/tabs --application/shared_components/user_interface/templates/list/menu_popup --application/shared_components/user_interface/templates/list/links_list --application/shared_components/user_interface/templates/report/timeline --application/shared_components/user_interface/templates/report/content_row --application/shared_components/user_interface/templates/report/media_list --application/shared_components/user_interface/templates/report/value_attribute_pairs_row --application/shared_components/user_interface/templates/report/value_attribute_pairs_column --application/shared_components/user_interface/templates/report/badge_list --application/shared_components/user_interface/templates/report/contextual_info --application/shared_components/user_interface/templates/report/standard --application/shared_components/user_interface/templates/report/comments --application/shared_components/user_interface/templates/report/alerts --application/shared_components/user_interface/templates/report/cards --application/shared_components/user_interface/templates/report/search_results --application/shared_components/user_interface/templates/label/hidden --application/shared_components/user_interface/templates/label/optional --application/shared_components/user_interface/templates/label/optional_above --application/shared_components/user_interface/templates/label/optional_floating --application/shared_components/user_interface/templates/label/required --application/shared_components/user_interface/templates/label/required_above --application/shared_components/user_interface/templates/label/required_floating --application/shared_components/user_interface/templates/breadcrumb/breadcrumb --application/shared_components/user_interface/templates/popuplov --application/shared_components/user_interface/templates/calendar/calendar --application/shared_components/user_interface/themes --application/shared_components/user_interface/theme_style --application/shared_components/user_interface/theme_files --application/shared_components/user_interface/template_opt_groups --application/shared_components/user_interface/template_options --application/shared_components/globalization/language --application/shared_components/logic/build_options --application/shared_components/globalization/messages --application/shared_components/globalization/dyntranslations --application/shared_components/security/authentications/oracle_apex_accounts --application/user_interfaces --application/user_interfaces/combined_files --application/pages/page_00000 --application/pages/page_00001 --application/pages/page_00002 --application/pages/page_00003 --application/pages/page_00004 --application/pages/page_00005 --application/pages/page_00006 --application/pages/page_00007 --application/pages/page_00008 --application/pages/page_00009 --application/pages/page_00010 --application/pages/page_00011 --application/pages/page_00012 --application/pages/page_09999 --application/pages/page_10000 --application/pages/page_10010 --application/pages/page_10011 --application/pages/page_10012 --application/pages/page_10013 --application/pages/page_10014 --application/end_environment ...done
You are ready now to log in to your workspace.
Just remember that the workspace administrator is now using Database Credentials. Use the password you have set during the creation of the schema.
Post Migration Tasks
You may need to complete additional tasks after migration to Autonomous Database before you can fully utilize your APEX applications and RESTful services. Please review Restrictions and Limitations for Oracle Application Express with Autonomous Transaction Processing in Using Oracle Autonomous Transaction Processing.
Unsupported APEX Authentication Schemes
Oracle APEX in Autonomous Database does not support certain application authentication schemes. If your application in on-premises database uses an authentication scheme not available in Autonomous Database, you must switch to a different authentication scheme after importing this application into Autonomous Database.
To change authentication scheme for your APEX application in Autonomous Database:
- Open your application in APEX App Builder.
- Click Shared Components, then click Authentication Schemes in the Security section.
- Click Create, click Next.
- Enter the Name for your new authentication scheme and select a supported Scheme Type (for example, Application Express Accounts).
- Click Create Authentication Scheme.
- Run the application.
Applications which Send Email
If your applications in on-premises database send outbound email using APEX_MAIL or built-in Application Express dialogs, further configuration is required in Autonomous Database. See Send Email from Oracle Application Express in Using Oracle Autonomous Transaction Processing documentation to learn more.
Happy APEXing!