Connect to APEX Newly Created Oracle Schema with Toad

Here is a tutorial of creating apex workspace, schema and import application.
1. Go to apex site and log into internal space use admin/password.
From manage workspace>> create workspace >> name workspace as "DASH01" and go to next step.


2.  Make sure you choose 'NO' for Re-use existing schema. Fill in the rest required filed. Here Schema name and schema password will be used to connect to this schema from Toad.

3. Fill in Admin user name, password and email as required. Click create workspace in the next step.

4.  Start Toad, create new connection
User/Schema: DASH01
password: where you provided as in step 2
In Dire Tab, provide Host/Port/SID.

5.  Go to old APEX application site as regular user.
Go to Home>>SQL Workshop>> Utilities>>Generate DDL and click create script. In the "Object Type" step, check Table. Select "Check All" in "Object Name" step.






6. The generated script will be at SQL Workshop>> SQL Scripts
Open and execute the script in Toad will create all the tables in new APEX.

7. Connect to old APEX schema in Toad. Choose Database>>Schema Browser
Select all tables and>>choose "copy data to another schema" from right click.