3.12.11.1 Exporting and Importing Using SQLcl

Export workspaces, applications, and related files from a command line using Oracle SQL Developer Command Line (SQLcl) release 22.1 and later.

SQLcl is a free Java-based command-line interface for Oracle Database. Use SQLcl to execute SQL and PL/SQL statements interactively or as as a batch file. SQLcl provides inline editing, statement completion, command recall, and also supports existing SQL*Plus scripts.

• Downloading and Installing SQLcl
  Download and install Oracle SQL Developer Command Line (SQLcl) for free.
• Starting SQLcl and Connecting to the Database
  Learn how to start SQLcl and connect to the database.
• Exiting SQLcl
  Learn how to exit SQLcl.
• Listing Applications
  Use SQLcl to list all or selected APEX applications in a workspace.
• Listing Components in an Application
  Use SQLcl to list all or selected components in an APEX application.
• Exporting One or More Applications
  Use SQLcl to export a single APEX application or all applications in a workspace.
• Exporting a Workspace
  Export a workspace using the apex export command with the -expWorkspace option.
• Exporting Workspace Static Files
  Export a workspace static files using the apex export command and -expFiles option.
• Installing an Application
  Install an APEX application into a target environment by running a SQL script.
• Importing a Workspace
  Import an APEX workspace into a target environment.
• Importing Workspace Static Files
  Import APEX workspace static files into a target environment.
• Synchronizing Feedback Among Environments
  Learn about best practices for synchronizing feedback from development, test, and production environments.
• Displaying Application Usage
  View a summary of APEX application usage.

See Also:

• Working with SQLcl in Oracle SQLcl User’s Guide

• Deploying an Application in Oracle APEX App Builder User’s Guide