CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle12c
Arif Sher Khan
Arif Sher Khan

Reputation: 585

Deploy Oracle Apex app through different schema of database

I want to install apex app. I know of two ways to install any app.

  1. Importing export file via Apex designer interface from the same workspace
  2. Or, copy the app export file let's say f101.sql and execute that as script directly in SQL developer using the database Schema (which is connected to workspace)

I want to do something similar like 2, but instead of using same Schema, I want to use different Schema to execute script but install into the same workspace.

Example: f101.sql is app export of workspace finance_ws, which is connected to finance_schema of database. I have another schema deployment_schema. Could I execute f101.sql file in deployment_schema so that it gets deployed in finance_ws workspace?

Upvotes: 0

Views: 1304

Answers (2)

Arif Sher Khan
Arif Sher Khan

Reputation: 585

deployment_schema should have APEX_ADMINISTRATOR_ROLE assigned. Once assigned, we can deploy/execute any app through deployment_schema in any workspace which exist in that database

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 142778

I'd

  • create a new workspace (let's call it deployment_ws)
  • designate it to deployment_schema
  • create a developer in that workspace (let's call it arif)
  • connect to deployment_ws as arif
  • import f101.sql

Perhaps you can do it as you wanted, but ... I find the above approach simpler.

[EDIT]

You'd want to have only one workspace (which is FINANCE_WS), but import F101.SQL into it so that one application works on finance_schema, and another one on deployment_schema.

As you can't have two applications with the same ID, you'll have to import F101.SQL and change application ID during import (that's on the "Install application" tab. Use either "auto assign new application ID" or "change application ID" (manually).

On the same import page, you'll see the Parsing schema property - change it to deployment_schema. If you don't see it in the list of values, connect as admin into internal workspace and designate deployment_schema to finance_ws.

I guess that's what you, actually, wanted ...

Upvotes: 1

Related Questions