1. Using Oracle Database Cloud Schema Service
  2. Oracle Database Cloud Schema Service Security Lockdown Implementation Considerations
  3. Oracle Database Cloud Schema Service Specific Limitations

Oracle Database Cloud Schema Service Specific Limitations

The core of the Schema Service development environment is Oracle Application Express, which is also a no-cost option for all versions of the Oracle Database since Oracle Database 10g Release 2. The following areas of functionality are limited when used for applications within the Schema Service environment:

  • Background Jobs - A Schema Service is able to submit jobs, but is limited to a maximum of 10 defined jobs and 5 jobs running or scheduled at any one time. Jobs are subject to resource limitations imposed by Database Resource Manager, similar to the way overall resources are limited as described below. These limits and conditions are implemented through a PL/SQL package called CLOUD_SCHEDULER.

  • E-mails - Schema Service is limited to 5,000 emails in a 24 hour period.

  • BI Publisher is not available for Schema Service.

  • Outbound Web Service calls - Schema Service applications can make outbound Web Service calls through the APEX_WEB_SERVICE PL/SQL package. These calls can only use HTTPS or SSL and use a proxy server from within the Oracle Cloud. There is a limit of 50,000 calls in a 24 hour period.

  • Oracle Application Express Public API Packages — The APEX_LDAP API package is not available.

  • Identity Domain for Schema Service cannot be changed.

  • Files uploaded must not exceed 100MB. This limit is imposed by a parameter setting in the ORDS and applies to application imports from the Oracle Application Express Application Builder, static file uploads, script imports from Oracle Application Express SQL Workshop, file uploads in Oracle Application Express applications, and so on. For files larger than 100MB, please use Oracle SQL Developer. See Use Oracle SQL Developer for Data Loading.