SQL Commands
Autonomous Database allows most of the SQL commands available in Oracle Database. To ensure the security and the performance of Autonomous Database, some SQL commands are restricted.
This section provides a list of SQL command limitations that are required to protect security and for the performance integrity of Autonomous Databases. Most of the standard SQL and PL/SQL syntax and constructs available with Oracle Database work in Autonomous Databases.
If you try to use a restricted SQL command the system reports:
ORA-01031: insufficient privileges
This error indicates that you are not allowed to run the SQL command in Autonomous Database.
The following SQL statements are not available in Autonomous Database:
-
ADMINISTER KEY MANAGEMENT
: By default Autonomous Database uses Oracle-managed encryption keys. Using Oracle-managed keys, Autonomous Database creates and manages the encryption keys that protect your data and Oracle handles rotation of the TDE master key.If you want customer-managed keys, a master encryption key in the Oracle Cloud Infrastructure Vault is used to generate the TDE master key on Autonomous Database. See Managing Encryption Keys on Autonomous Database for more information.
-
CREATE TABLESPACE
,ALTER TABLESPACE
, andDROP TABLESPACE
: Autonomous Database automatically configures default data and temporary tablespaces for the database. Adding, removing, or modifying tablespaces is not allowed. Autonomous Database creates one tablespace or multiple tablespaces automatically depending on the storage size. -
CREATE DATABASE LINK
Use
DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK
to create database links in Autonomous Database. See Use Database Links with Autonomous Database for more information. -
CREATE LIBRARY
SQL Statements with Restrictions in Autonomous Database
The following DDL statements are available in Autonomous Database with some restrictions:
SQL Command | Restrictions |
---|---|
|
Only the following clauses are allowed:
|
|
Using Using See Create Users on Autonomous Database for information on the password parameter values defined in the default profile. |
|
Only the following clauses are allowed:
|
|
|
|
The following clause is ignored: The The |
|
For restrictions, see |
|
See Manage Password Complexity on Autonomous Database for more information. Using See Create Users on Autonomous Database for information on the password parameter values defined in the default profile. |
|
For restrictions, see |
|
The |
|
The following clause is ignored:
The |
CREATE TABLE Restrictions
XMLType
tables using XML schema-based storage are not
allowed. See Oracle XML DB for more information.
The clauses not in this list are allowed.
Clause | Comment |
---|---|
|
Ignored |
|
Ignored |
|
Ignored |
|
The See LOB_compression_clause for more information. |
|
Ignored |
|
Ignored |
|
Creates a regular table with a primary key. Using
the |
|
Ignored |
ALTER TABLE Restrictions
The clauses not in this list are allowed.
Clause | Comment |
---|---|
|
Ignored |
|
Ignored |
|
Ignored |
|
Ignored |
|
Ignored |
|
Ignored |
|
Ignored |
|
Ignored |
|
Ignored |
Parent topic: Notes for Users Migrating from Other Oracle Databases