APEX Applications

Check

@/u01/dba/apx/apexapps.sql

set linesize 200

set pagesize 40

column application_id format 999999999999999

column application_name format a60

column version format a12

column owner format a15


SELECT application_id, workspace, application_name, owner, version

FROM apex_applications 

WHERE workspace != 'INTERNAL'

AND availability_status !='Unavailable'

ORDER BY application_id; 

To identify all APEX Applications on Source database (including Unavailable apps)

@/u01/dba/apx/apexallapps.sql

set linesize 200

set pagesize 40

column application_id format 999999999999999

column application_name format a60

column version format a12

column owner format a15

column availability_status format a30

column workspace format a30


SELECT application_id, workspace, application_name, owner, version, availability_status

FROM apex_applications

WHERE workspace != 'INTERNAL'

ORDER BY application_id;

Bibliography