You may have noticed in APEX 24.1 and beyond, a new option appeared when you are exporting your applications in the APEX Builder.
As per the docs
The rationale here is straightforward – if you are delivering apps to customers (especially customers outside your organization), then you might not want to have your user account details (or email addresses etc) scattered throughout the export file contents.
If you wanted to retain this information in your own development/testing environments, you can toggle the setting appropriately, which raises the question:
What if you are not using the Builder to export your applications?
If you’re using PL/SQL, the APEX_EXPORT API has a new parameter to allow your choose it
SQL> desc APEX_EXPORT
...
FUNCTION GET_APPLICATION RETURNS TABLE
Argument Name Type In/Out Default?
------------------------- -------------------- ------ --------
P_APPLICATION_ID NUMBER IN
P_TYPE VARCHAR2 IN Y
P_SPLIT PL/SQL BOOLEAN IN Y
P_WITH_DATE PL/SQL BOOLEAN IN Y
P_WITH_IR_PUBLIC_REPORTS PL/SQL BOOLEAN IN Y
P_WITH_IR_PRIVATE_REPORTS PL/SQL BOOLEAN IN Y
P_WITH_IR_NOTIFICATIONS PL/SQL BOOLEAN IN Y
P_WITH_TRANSLATIONS PL/SQL BOOLEAN IN Y
P_WITH_PKG_APP_MAPPING PL/SQL BOOLEAN IN Y
P_WITH_ORIGINAL_IDS PL/SQL BOOLEAN IN Y
P_WITH_NO_SUBSCRIPTIONS PL/SQL BOOLEAN IN Y
P_WITH_COMMENTS PL/SQL BOOLEAN IN Y
P_WITH_SUPPORTING_OBJECTS VARCHAR2 IN Y
P_WITH_ACL_ASSIGNMENTS PL/SQL BOOLEAN IN Y
P_COMPONENTS TABLE IN Y
P_WITH_AUDIT_INFO VARCHAR2 IN Y
P_WITH_RUNTIME_INSTANCES TABLE IN Y
If you’re using SQLcl, you can use the following options in your “apex export” command
SQL> apex export -applicationid 100
Exporting Workspace ASKTOM - application 100:asktom
File f100.sql created
SQL> apex export -applicationid 100 -audittype NAMES_AND_DATES
Exporting Workspace ASKTOM - application 100:asktom
File f100.sql created
SQL> apex export -applicationid 100 -audittype DATES_ONLY
Exporting Workspace ASKTOM - application 100:asktom
File f100.sql created
Happy exporting!




Got some thoughts? Leave a comment