You may have noticed in APEX 24.1 and beyond, a new option appeared when you are exporting your applications in the APEX Builder.

image

As per the docs

image

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trending