Previous Next JavaScript must be enabled to correctly display this content

## 3.11.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

Parent topic: Exporting and Importing Using SQLcl