3.12.11.1.10 Importing a Workspace

Import an APEX workspace into a target environment.

To importing an APEX workspace into a target environment:

1. Connect SQLcl to the target environment's database as a user with the APEX_ADMINISTRATOR_ROLE privilege or as a DBA account.

2. Run the script produced by the workspace export into a target environment.

Workspace export script in the following example is is named w1908816359534887.sql .

SQL> show user
USER is "ADMIN"
@w1908816359534887.sql

This script would produce output similar to the following:

--application/set_environment
WORKSPACE 1908816359534887
Creating workspace EXAMPLES...
Creating Groups...
Creating group grants...
Creating Users...
...RESTful Services
SCHEMA EXAMPLES - User Interface Defaults, Table Defaults
User Interface Defaults, Attribute Dictionary
...done