32 APEX_INSTANCE_ADMIN

The APEX_INSTANCE_ADMIN package provides utilities for managing an Oracle APEX runtime environment.

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_AUTO_PROV_RESTRICTIONS Procedure
  
• ADD_SCHEMA Procedure
  
• ADD_WEB_ENTRY_POINT Procedure
  
• ADD_WORKSPACE Procedure
  
• CREATE_CLOUD_CREDENTIAL Procedure
  
• CREATE_OR_UPDATE_ADMIN_USER Procedure
  
• CREATE_SCHEMA_EXCEPTION Procedure
  
• DB_SIGNATURE Function
  
• DROP_CLOUD_CREDENTIAL Procedure
  
• FREE_WORKSPACE_APP_IDS Procedure
  
• GET_PARAMETER Function
  
• GET_SCHEMAS Function
  
• GET_WORKSPACE_PARAMETER Procedure
  
• GRANT_EXTENSION_WORKSPACE Procedure
  
• IS_DB_SIGNATURE_VALID Function
  
• REMOVE_APPLICATION Procedure
  
• REMOVE_AUTO_PROV_RESTRICTIONS Procedure
  
• REMOVE_SAVED_REPORT Procedure
  
• REMOVE_SAVED_REPORTS Procedure
  
• REMOVE_SCHEMA Procedure
  
• REMOVE_SCHEMA_EXCEPTION Procedure
  
• REMOVE_SCHEMA_EXCEPTIONS Procedure
  
• REMOVE_SUBSCRIPTION Procedure
  
• REMOVE_WEB_ENTRY_POINT Procedure
  
• REMOVE_WORKSPACE Procedure
  
• REMOVE_WORKSPACE_EXCEPTIONS Procedure
  
• RESERVE_WORKSPACE_APP_IDS Procedure
  
• RESTRICT_SCHEMA Procedure
  
• REVOKE_EXTENSION_WORKSPACE Procedure
  
• SET_LOG_SWITCH_INTERVAL Procedure
  
• SET_PARAMETER Procedure
  
• SET_WORKSPACE_CONSUMER_GROUP Procedure
  
• SET_WORKSPACE_PARAMETER Procedure
  
• TRUNCATE_LOG Procedure
  
• UNLOCK_USER Procedure
  
• UNRESTRICT_SCHEMA Procedure
  
• VALIDATE_EMAIL_CONFIG Procedure