Specifications

This section outlines Oracle Database Cloud Schema Service specifications.

Topics:

Oracle Database Version and Edition

The current version of Oracle Database Cloud Schema Service is based on Oracle Database 11g Release 2, Enterprise Edition with each quarterly security patch set applied. The only option included in Schema Service is the Partitioning Option.

Components not Available

The following features and components are not part of the current version of Oracle Database Cloud Schema Service:

  • Oracle Database Extensions for .NET

  • Oracle Database Vault

  • Oracle Java VM

  • Oracle Label Security

  • Oracle Multimedia

  • Oracle OLAP

  • Oracle Spatial

  • Oracle Text

  • Oracle Warehouse Builder

Schemas and Data

The following schemas and data are not accessible in the Oracle Database Cloud Schema Service:

  • Sample schemas

  • Local Enterprise Manager repository

  • Oracle Data Mining RDBMS APIs for file access

Database Time Zone

Oracle Database Cloud Schema Service databases use UTC  (Coordinated Universal Time, +00:00 time zone offset) as the database and system time zone in all data centers. This system setting impacts dates returned by SYSDATE, SYSTIMESTAMP, column type TIMESTAMP WITH LOCAL TIMEZONE, and similar datetime functions, and cannot  be changed. 

In order to display dates in time zones other than UTC, please alter the database session time zone in your application and use CURRENT_TIMESTAMPLOCALTIMESTAMP and similar datetime functions.

See Datetime Functions in Database SQL Language Reference and APEX_UTIL.SET_SESSION_TIME_ZONE in Oracle Application Express API Reference.