Oracle® Cloud

What's New for Oracle Autonomous Data Warehouse


February 2019

What’s New for Autonomous Data Warehouse

Describes the Autonomous Data Warehouse features.

Here’s a summary of the Autonomous Data Warehouse additions and enhancements in this release.

Feature Description

Autonomous Data Warehouse Features

For an introduction to the features of Autonomous Data Warehouse, see About Autonomous Data Warehouse.

Database Limitations

For information on database limitations, see Autonomous Data Warehouse Cloud for Experienced Oracle Database Users.

February 2019

Feature Description

Application Continuity

You can now enable and disable Application Continuity. Application Continuity masks outages from end users and applications by recovering the in-flight work for impacted database sessions following outages. Application Continuity performs this recovery beneath the application so that the outage appears to the application as a slightly delayed execution.

See Enabling and Disabling Application Continuity for more information.

Documentation changes

Autonomous Data Warehouse documentation includes a new chapter that describes moving data to other Oracle databases. See Moving Data from Autonomous Data Warehouse to Other Oracle Databases for more information.

January 2019

Feature Description

Access Parquet files in Object Stores

Autonomous Data Warehouse allows you to directly query and load data stored as parquet files in object stores. You can also create external parquet format tables in object stores. See COPY_DATA Procedure for Parquet Files and CREATE_EXTERNAL_TABLE Procedure for Parquet Files for more information.

October 2018

Feature Description

Oracle Cloud Infrastructure Console changes

The Autonomous Data Warehouse console has a new layout and provides new buttons that improve the usability of Autonomous Data Warehouse. These changes include a new DB Connection button that makes it easier to download client credentials.

Documentation changes The documentation page for Autonomous Data Warehouse, Getting Started includes new role based topic links.

September 2018

Feature Description

Table compression methods

In addition to Hybrid Columnar Compression all table compression types are now available in Autonomous Data Warehouse. For more information, see Managing DML Performance and Compression.

Partitioned tables, indexes, and materialized views

Autonomous Data Warehouse now allows users to create partitioned tables, indexes, and materialized views. For more information, see Managing Partitions, Indexes, and Materialized Views.

Idle timeout changes

The idle timeout of 60 minutes is now lifted. Idle sessions that do not hold resources required by other sessions will not be terminated after 60 minutes now. For more information, see Managing Concurrency and Priorities on Autonomous Data Warehouse.

August 2018

Feature Description

The Oracle Cloud Infrastructure page has a new option Autonomous Transaction Processing

The sign in for Oracle Cloud Infrastructure now lists the new product, Oracle Autonomous Transaction Processing, in addition to Oracle Autonomous Data Warehouse.

July 2018

Feature Description

SQL Developer 18.2.0 and later without Keystore Password field for connections

When you connect to Autonomous Data Warehouse with SQL Developer 18.2.0 or later, you do not need to supply a keystore password. The keystore pasword was required in previous SQL Developer versions.

June 2018

Feature Description

New management interfaces

Autonomous Data Warehouse is now provisioned and managed using the native Oracle Cloud Infrastructure. This provides a more intuitive user interface to make managing your Autonomous Data Warehouse instances easier with additional capabilities including sorting and filtering.

For more information, see Oracle Help Center.

Better authorization management

With OCI Identity and Access Management (IAM) you can better organize and isolate your Autonomous Data Warehouse instances using Compartments and control what type of access a user or group of users have.

Built-in auditing

The OCI Audit service records use of Autonomous Data Warehouse application programming interface (API) endpoints as log events in JSON format. You can view, copy, and analyze audit events with standard log analysis tools or using the Audit service Console, the Audit APIs, or the Java SDK.

Availability of the Phoenix region

Autonomous Data Warehouse is now available in the Phoenix region in addition to Ashburn and Frankfurt regions.

User Assistance changes

The documentation, videos, and examples are updated on the Oracle Help Center to include the procedures to create and control Autonomous Data Warehouse instances with the Oracle Cloud Infrastructure Console.

A new Related Resources page shows related resources including the Autonomous Data Warehouse Forum .

Idle timeouts in database services

The idle timeouts for three database services, high, medium, and low, have now been relaxed. The previous idle timeout setting of 5 minutes will now apply to only idle sessions that hold resources needed by other active users. See Managing Concurrency and Priorities on Autonomous Data Warehouse.

May 2018

Feature Description

Oracle Cloud Infrastructure Object Storage Credentials

The name Swift Password is now Auth token. Use of Swift password in the documentation is now replaced with Auth token.

April 2018

Feature Description

Microsoft Azure Blob Storage integration

Autonomous Data Warehouse now supports Microsoft Azure Blob Storage for data loading and querying external data. You can load data from or run queries on files residing on Azure Blob Storage. See Loading Data from Files in the Cloud.

Manage files on the local file system

You can now list files residing on the local file system on Autonomous Data Warehouse, see LIST_FILES Function.

You can also remove files from the local file system. See DELETE_FILE Procedure.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Oracle Cloud What's New for Oracle Autonomous Data Warehouse


Copyright © 2018, 2019, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.