CREATE statements have a broad range of syntax and options. This list includes the allowed CREATE statements in Oracle Database Cloud Schema Service:

• CREATE DIMENSION

• CREATE FUNCTION

• CREATE INDEX

• CREATE INDEXTYPE

• CREATE OPERATOR

• CREATE PACKAGE

• CREATE PROCEDURE

• CREATE SEQUENCE

• CREATE TABLE

• CREATE TRIGGER

• CREATE TYPE

• CREATE VIEW

The following SQL statements cannot be used in the Oracle Database Cloud Schema Service:

• CREATE CLUSTER

• CREATE CONTEXT

• CREATE JOB (Background jobs can be created through the CLOUD_SCHEDULER package. See Schedule Background and Asynchronous Jobs)

• CREATE SYNONYM

• CREATE JAVA

• CREATE ROLE

• CREATE DIRECTORY

• CREATE TABLESPACE

• CREATE DATABASE LINK

• CREATE MATERIALIZED VIEW

• Some ALTER SESSION options, although most session level changes for NLS or character sets are still allowed

Additionally, parallel operations are not supported in the Schema Service, so any SQL DDL clauses that allow for parallel operations are not supported.

Oracle Database 11g Release 2 includes many PL/SQL packages to deliver extended functionality. The following sections list the PL/SQL packages that are part of Oracle Database Cloud Schema Service and some prominent packages which are not included.

The following PL/SQL packages and types are included in Oracle Database Cloud Schema Service:

• ANYDATA

• ANYDATASET

• ANYTYPE

• AQ$_AGENT

• AQ$_SIG_PROP

• AQ$_SUBSCRIBERS

• DBMS_APPLICATION_INFO

• DBMS_ASSERT

• DBMS_CRYPTO

• DBMS_DB_VERSION

• DBMS_FREQUENT_ITEMSET

• DBMS_LCR

• DBMS_LOB

• DBMS_METADATA

• DBMS_OUTPUT

• DBMS_RANDOM

• DBMS_SQL

• DBMS_STANDARD

• DBMS_STATS

• DBMS_TYPES

• All DBMS_XML% packages and types

• DBMS_XPLAN

• All DBMS_XQUERY% packages and types

• DBMSOUTPUT_LINESARRAY

• HTF

• HTP

• All Oracle Application Express API packages except for APEX_PLSQL_JOB and APEX_LDAP

• All ODCI% packages and types

• All OWA% packages and types

• PLITBLM

• SCN_TO_TIMESTAMP

• STANDARD

• STRAGG

• SYS_NT_COLLECT

• SYS_STUB_FOR_PURITY_ANALYSIS

• TIMESTAMP_TO_SCN

• UTL_COLL

• UTL_COMPRESS

• UTL_ENCODE

• UTL_GDK

• UTL_I18N

• UTL_IDENT

• UTL_LMS

• UTL_MATCH

• All UTL_NLA% packages and types

• UTL_RAW

• UTL_REF

• WPG_DOCLOAD

• XMLGENFORMATTYPE

• XMLSEQUENCE

• XMLSEQUENCEFROMREFCURSOR

• XMLSEQUENCEFROMREFCURSOR2

• XMLSEQUENCEFROMXMLTYPE

• XMLSEQUENCETYPE

• XMLTYPE

• XMLTYPEEXTRA

• XMLTYPEI

• All XQ% packages and types

All packages not listed here are not available in the Schema Service. Exceptions cannot be made.