18 APEX_INSTANCE_ADMIN
The APEX_INSTANCE_ADMIN
package provides utilities for managing an
Oracle Application Express runtime environment. You use the
APEX_INSTANCE_ADMIN
package to get and set email settings, Oracle
Wallet settings, report printing settings and to manage schema to workspace mappings.
APEX_INSTANCE_ADMIN
can be executed by the SYS
or
SYSTEM
database users and any database user granted the role
APEX_ADMINISTRATOR_ROLE
.
- Available Parameter Values
- ADD_SCHEMA Procedure
- ADD_WORKSPACE Procedure
- CREATE_SCHEMA_EXCEPTION Procedure
- DB_SIGNATURE Function
- FREE_WORKSPACE_APP_IDS Procedure
- GET_PARAMETER Function
- GET_SCHEMAS Function
- GET_WORKSPACE_PARAMETER
- IS_DB_SIGNATURE_VALID Function
- REMOVE_APPLICATION Procedure
- REMOVE_SAVED_REPORT Procedure
- REMOVE_SAVED_REPORTS Procedure
- REMOVE_SCHEMA Procedure
- REMOVE_SCHEMA_EXCEPTION Procedure
- REMOVE_SCHEMA_EXCEPTIONS Procedure
- REMOVE_SUBSCRIPTION Procedure
- REMOVE_WORKSPACE Procedure
- REMOVE_WORKSPACE_EXCEPTIONS Procedure
- RESERVE_WORKSPACE_APP_IDS Procedure
- RESTRICT_SCHEMA Procedure
- SET_LOG_SWITCH_INTERVAL Procedure
- SET_WORKSPACE_PARAMETER
- SET_PARAMETER Procedure
- SET_WORKSPACE_CONSUMER_GROUP Procedure
- TRUNCATE_LOG Procedure
- UNRESTRICT_SCHEMA Procedure
- VALIDATE_EMAIL_CONFIG Procedure