Apex Workspace Creation and Import application.

Description :
In this blog, we are going to see step-by-step oracle application express workspace creation and import the application from the workspace and run the application.

High-level steps:-

1. Pre-request checks.
2. Export schema in database and application in apex.
3. Drop or create exported schema before import with required 
privileges and tablespace.
4. Import schema in database level.
5. Create a new workspace in apex.
6. Edit privileges and create a password for workspace.
7. Login the workspace as admin user.
8. Import application into the workspace.
9. Install and run the application.

Step 1:- Pre-request check.

Check application schema in a database and map tablespace and size of the schema.

Step 2:- Export schema in database and application in apex.

After that export the schema and move it to the local machine using win SCP.
Login to the apex workspace select the managed workspace and users in that mention the export option to export the workspace SQL format file.

Step 3:- Drop or create exported schema before import with required privileges and tablespace. Step 4:- Import schema at the database level.
       We need to import the schema in the database using the dump file.
Step 5:- Create a New workspace in the apex.
     1. log in as Admin user.
     2. Select Create workspace option.
      3. Provide workspace name and click next.
    4. Already we create a schema at the database level so we select the reuse option as yes and select the schema.
     5. Provide username and password to the workspace.
     6. Select Create workspace option.
     7. Change workspace details give edit workspace option.
Step 6:- Edit privileges and create an application for the workspace.
      1. Account privilege changes.
    2. Create a password for the workspace.
Step 7:- Create a new application in the workspace.
       1. log in to the Workspace with workspace name, username, and password.
     2. Select the application builder option in that we create an application or we can import an existing application.
     3. Select create an application we can create the new application.
     4. Run the application and Login as the workspace username and password.
Step 8:- Importing Existing application to the workspace.
       1. Select the import option in the application builder.
     2. Drag the exported SQL file to that location and click next.
   3. select reuse application id and install the application. after install run the application.
Step 9:- Login and check the application working fine.
********************************************************************************

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

One thought on “Apex Workspace Creation and Import Application.”

Could You please tell me sir.. How to check application schema in a database level

Apex Workspace Creation and Import Application.

Apex Workspace Creation and Import application.

Share this:

Like this:

One thought on “Apex Workspace Creation and Import Application.”