Table of Contents
- Title and Copyright Information
- Preface
-
1
Overview
- What's New
- About Autonomous Database
- Get Help and Contact Support
- Service Level Objectives (SLOs)
-
How Is Autonomous Database Billed?
- Autonomous Database Billing Summary
-
Compute Models in Autonomous Database
-
ECPU Compute Model Billing
Information
- Billing Information: Autonomous Transaction Processing ECPU Compute Model
- Billing Information: Autonomous Data Warehouse ECPU Compute Model
- Billing Information: Autonomous JSON Database ECPU Compute Model
- Billing Information: APEX Service ECPU Compute Model
- Billing Information: Autonomous Database for Developers
- OCPU Compute Model Billing Information
-
ECPU Compute Model Billing
Information
- Oracle Autonomous Database Serverless Features Billing
- Oracle Autonomous Database Serverless Billing for Database Tools
- Autonomous Database for Developers Billing and Tenancy Service Limit
- Always Free Autonomous Database
-
Autonomous Database for Developers
- Resource Restrictions with Autonomous Database for Developers
- Oracle Database Versions with Autonomous Database for Developers
- Supported Features with Autonomous Database for Developers
- Provisioning and Cloning Workflow with Autonomous Database for Developers
- Upgrade Autonomous Database for Developers Instance to a Full Paid Instance
- Features Not Available in Autonomous Database for Developers
- 2 Quick Start
-
3
Tasks
- Provision an Autonomous Database
-
Connect to Autonomous Database
- About Connecting to an Autonomous Database Instance
-
Connect to Autonomous Database Using a Client
Application
- About Connecting to Autonomous Database Using a Client Application
- Prepare for Oracle Call Interface, ODBC, and JDBC OCI Connections with Wallets (mTLS)
- Prepare for Oracle Call Interface, ODBC, and JDBC OCI Connections Using TLS Authentication
- Prepare for JDBC Thin Connections
- Connect Microsoft .NET, Visual Studio Code, and Visual Studio with a Wallet (mTLS)
- Connect Microsoft .NET, Visual Studio Code, and Visual Studio Without a Wallet
- Connect Node.js and other Scripting Languages (mTLS)
- Connect Node.js, and Other Scripting Languages Without a Wallet
- Connect Power BI and Microsoft Data Tools to Autonomous Database
- Connect Python Applications to Autonomous Database
- Connect Go Applications to Autonomous Database
- Download Database Connection Information
- Connect to Autonomous Database Using Oracle Database Tools
- Connect with Built-In Oracle Database Actions
- Connect with JDBC Thin Driver
- Preparing for Oracle Call Interface Connections
- Predefined Database Service Names for Autonomous Database
- Connect with Oracle Analytics Desktop
- Connect with Oracle Analytics Cloud
-
Connection and Networking Options
and Features
- Using ACLs, VCNs, and Private Endpoints with Autonomous Database
- Connect with Oracle Cloud Infrastructure FastConnect
- Access Autonomous Database with VCN Transit Routing
- Access Autonomous Database with Service Gateway
- Use Database Resident Connection Pooling with Autonomous Database
- Use TCP Fast Open (TFO) to Connect Clients to Autonomous Database
- Best Practices for Low Latency Connections with Autonomous Database
- View Network Information on the OCI Console
-
Manage Users
- Create Users on Autonomous Database
- Remove Users
- Manage User Profiles with Autonomous Database
- Manage User Roles and Privileges
- Create and Update User Accounts for Oracle Machine Learning
-
Use Identity and Access Management
(IAM) Authentication with Autonomous Database
- About Identity and Access Management (IAM) Authentication with Autonomous Database
- Prerequisites for Identity and Access Management (IAM) Authentication on Autonomous Database
- Enable Identity and Access Management (IAM) Authentication on Autonomous Database
- Create Identity and Access Management (IAM) Groups and Policies for IAM Users
- Add IAM Users on Autonomous Database
- Add IAM Roles on Autonomous Database
- Create IAM Database Password for IAM Users
-
Connect to Autonomous Database with Identity and Access
Management (IAM) Authentication
- About Connecting to an Autonomous Database Instance Using IAM
- Configuring a Client Connection for SQL*Plus That Uses an IAM Database Password
- Configuring a Client Connection for SQL*Plus That Uses an IAM Token
- Use Instance Principal to Access Autonomous Database with Identity and Access Management (IAM) Authentication
- Configure IAM Proxy Authentication
- Disable Identity and Access Management (IAM) Authentication on Autonomous Database
- Accessing a Database Cross-Tenancy Using an IAM Integration
- Notes for Using Autonomous Database Tools with Identity and Access Management (IAM) Authentication
-
Use Azure Active Directory (Azure
AD) with Autonomous Database
- About Integrating Oracle Autonomous Database with Microsoft Entra ID
- Enable Azure AD Authentication on Autonomous Database
- Map Oracle Database Schemas and Roles for Azure AD
- Azure AD Client Configuration and Access for Autonomous Database
- Testing the Accessibility of the Entra ID Endpoint
-
Use Microsoft Active Directory
with Autonomous Database
- Prerequisites to Configure CMU with Microsoft Active Directory on Autonomous Database
- Configure CMU with Microsoft Active Directory on Autonomous Database
- Kerberos Authentication for CMU with Microsoft Active Directory
- Add Microsoft Active Directory Roles on Autonomous Database
- Add Microsoft Active Directory Users on Autonomous Database
- Tools Restrictions with Active Directory on Autonomous Database
- Connect to Autonomous Database with Active Directory User Credentials
- Verify Active Directory User Connection Information with Autonomous Database
- Remove Active Directory Users and Roles on Autonomous Database
- Disable Active Directory Access on Autonomous Database
- Configure Kerberos Authentication with Autonomous Database
-
Create Credentials or Configure Policies and Roles
- Manage Credentials
- Use Vault Secret Credentials
-
Configure Policies and Roles to Access Resources
-
Use Resource Principal to Access
Oracle Cloud
Infrastructure Resources
- About Using Resource Principal to Access Oracle Cloud Infrastructure Resources
- Perform Prerequisites to Use Resource Principal with Autonomous Database
- Enable Resource Principal to Access Oracle Cloud Infrastructure Resources
- Disable Resource Principal on Autonomous Database
- Use Resource Principal with DBMS_CLOUD
-
Use Amazon Resource Names (ARNs)
to Access AWS Resources
- About Using Amazon Resource Names (ARNs) to Access AWS Resources
- Perform AWS Management Prerequisites to Use Amazon Resource Names (ARNs)
- Perform Autonomous Database Prerequisites to Use Amazon ARNs
- Create Credentials with ARN Parameters to Access AWS Resources
- Update Credentials with ARN Parameters for AWS Resources
- Use Azure Service Principal to Access Azure Resources
-
Use Google Service Account to
Access Google Cloud Platform Resources
- About Using a Google Service Account to Access Google Cloud Resources
- Enable Google Service Account and Find the GCP Service Account Name
- Assign Roles to the Google Service Account and Provide Access for GCP Resources
- Use Google Service Account with DBMS_CLOUD
- Disable Google Service Account
- Google Service Account Notes
-
Use Resource Principal to Access
Oracle Cloud
Infrastructure Resources
-
Load Data
- About Data Loading
- Load Data with Oracle Database Actions
-
Load Data from Files in the Cloud
- Create Credentials and Copy Data into an Existing Table
- Create Credentials and Load Data Pump Dump Files into an Existing Table
-
Load JSON on Autonomous Database
- About Loading JSON Documents
- Load a JSON File of Line-Delimited Documents into a Collection
- Load an Array of JSON Documents into a Collection
- Monitor and Troubleshoot COPY_COLLECTION Loads
- Textual JSON Objects That Represent Extended Scalar Values
- Create Credentials and Copy JSON Data into an Existing Table
- Monitor and Troubleshoot Loads
- Examples for Loading Data into Autonomous Database
- Import Data Using Oracle Data Pump on Autonomous Database
- Load Data from Local Files with Oracle Database Actions
- Load Data or Query Data from Files in a Directory
- Load Data from Local Files Using SQL*Loader
- Use Data Pipelines for Continuous Load and Export
-
The Data Load Page
-
The Data Load Page
- Data Studio Preferences
- Managing Connections
-
Loading Data
- Use OCI Language Service Capabilities in Data Studio
- Use OCI Document Understanding to extract Tables from Images
- Use GeoJSON in Data Load
- Loading Data From Local Files
- Loading Data from Other Databases
- Loading Data from Cloud Storage
- Load Apache Iceberg Tables
- Loading Data from AI Source
- Loading Data from File System
- Loading Data from Share
- Create Live Feed from Data Load
- Linking Data
- Feeding Data
-
The Data Load Page
-
Transform Data Using Data
Studio
-
The Data Transforms Page
- Access Oracle Data Transforms From Data Studio
- Data Transforms Notes
-
Work with Connections
- Supported Connection Types
- Create Custom Connectors
- Create a Data Transforms Connection for Remote Data Load
- Create a Delta Share Connection
- Create an Oracle Business Intelligence Cloud Connector Connection
- Create an Oracle Financials Cloud Connection
- Create and Use an Oracle NetSuite Connection
- Create an Oracle Object Storage Connection
- Create a REST Server Connection
- Create a Data Load
- Run a Data Load
- Work with Data Entities
- Work with Projects
- Create a Data Flow
- Schedule Data Flows or Workflows
- Monitor Status of Data Loads, Data Flows, and Workflows
- Introduction to Workflows
- Create a Variable
- Create and Manage Jobs
- Export Objects
-
The Data Transforms Page
- View Data Pump Jobs and Import Data with Data Pump
-
Link Data
-
Link to Object Storage Data
- Query External Data
- Access ORC, Parquet or Avro file types
- Query External Tables with Implicit Partitioning
- Access partitioned object storage data
- Querying External Partitioned Data
- Query Hybrid Partitioned Data
- Query External Data Pump Dump Files
- Query Big Data Service Hadoop (HDFS) Data from Autonomous Database
- Integrate Data Lake metadata with Data Catalog
- Query External Data with AWS Glue Data Catalog
- Query Apache Iceberg Tables
- Validate External Data
- Validate External Partitioned Data
- Validate Hybrid Partitioned Data
- View Logs for Data Validation
-
Use Database Links
-
Create Database Links from
Autonomous Database to Another Autonomous Database
- Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database
-
Create Database Links from Autonomous Database to an Autonomous Database on a Private Endpoint
- Prerequisites for Database Links from Autonomous Database to a Target Autonomous Database on a Private Endpoint
- Create Database Links to a Target Autonomous Database on a Private Endpoint without a Wallet (TLS)
- Create Database Links to a Target Autonomous Database on a Private Endpoint with a Wallet (mTLS)
- Database Link Notes with a Target that is an Autonomous Database
- Create Database Links to an Oracle Database that is not an Autonomous Database
-
Create Database Links to
Non-Oracle Databases
- Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity
-
Create Database Links to
Non-Oracle Databases with Customer-Managed Heterogeneous Connectivity
- Prerequisites to Create Database Links to Non-Oracle Databases with Customer-Managed Heterogeneous Connectivity
- Create Database Links with Customer-Managed Heterogeneous Connectivity to Publicly Accessible Non-Oracle Databases
- Create Database Links with Customer-Managed Heterogeneous Connectivity to Non-Oracle Databases on a Private Endpoint
- Create Database Links from Other Databases to Autonomous Database
- Drop Database Links
-
Create Database Links from
Autonomous Database to Another Autonomous Database
-
Link to Object Storage Data
- Call Web Services
-
Move Files
- Create and Manage Directories
- Copy Files Between Object Store and a Directory in Autonomous Database
-
Bulk Operations for Files in the
Cloud
- About Bulk File Operations
- Bulk Copy Files in Cloud Object Storage
- Bulk Move Files Across Cloud Object Storage
- Bulk Download Files from Cloud Object Storage
- Bulk Upload Files to Cloud Object Storage
- Bulk Delete Files from Cloud Object Storage
- Monitor and Troubleshoot Bulk File Loads
- Notes for Bulk File Operations
- Replicate Data
-
Export Data
- Export Data to Object Store as CSV, JSON, or XML using EXPORT_DATA
- Export Data to a Directory Location
- Export Data with Data Pump to an Autonomous Database Directory
- Export Data with Data Pump to Object Store
- Export Data to Object Store as Oracle Data Pump Files using EXPORT_DATA
- Download Dump Files, Run Data Pump Import, and Clean Up Object Store
- Access Log Files for Data Pump Export
- Oracle GoldenGate Capture for Oracle Autonomous Database
-
Data Sharing
-
Use Cloud Links for Read Only Data
Access on Autonomous Database
- About Cloud Links on Autonomous Database
- Grant Cloud Links Access for Database Users
- Register or Unregister a Data Set
- Register or Unregister a Data Set in a Different Region
- Register a Data Set with Authorization Required
- Register a Data Set with Offload Targets for Data Set Access
- Use Cloud Links from a Read Only Autonomous Database Instance
- Find Data Sets and Use Cloud Links
- Enable Caching for a Cloud Link Consumer
- Revoke Cloud Links Access for Database Users
- Monitor and View Cloud Links Information
- Define a Virtual Private Database Policy to Secure a Registered Data Set
- Notes for Cloud Links
-
Use Pre-Authenticated Request URLs
for Read Only Data Access on Autonomous Database
- About Pre-Authenticated Request (PAR) URLs on Autonomous Database
- Generate a PAR URL for a Table or a View
- Generate a PAR URL with a Select Statement
- Define a Virtual Private Database Policy to Secure PAR URL Data
- List PAR URLs
- Use a PAR URL to Access Data
- Use PAR URLs to Access Data and View in Table Format
- Invalidate PAR URLs
- Monitor and View PAR URL Usage
- Notes for Using PAR URLs to Share Data
- Share Data with Data Studio
-
Use Cloud Links for Read Only Data
Access on Autonomous Database
-
Develop
-
Use APEX with Autonomous Database
- About Oracle APEX
- Access Oracle APEX Administration Services
- Create Oracle APEX Workspaces in Autonomous Database
- Access Oracle APEX App Builder
- Create Oracle APEX Developer Accounts
- Load Data from the Cloud into Oracle APEX
- Use JSON Data with Oracle APEX
- Use Web Services with Oracle APEX
- Send Email from Oracle APEX
- Control Oracle APEX Upgrades
- Access Oracle APEX, Oracle REST Data Services, and Developer Tools Using a Vanity URL
- Oracle APEX Limitations on Autonomous Database
- Use JSON with Autonomous Database
-
Develop RESTful Services in Autonomous Database
- About Oracle REST Data Services in Autonomous Database
- Access RESTful Services and SODA for REST
- Develop with Oracle REST Data Services on Autonomous Database
- Use SODA for REST with Autonomous Database
- Access Oracle REST Data Services, Oracle APEX, and Developer Tools Using a Vanity URL
- About Customer Managed Oracle REST Data Services on Autonomous Database
- Use Oracle Database API for MongoDB
-
Send Email and Notifications on
Autonomous Database
- Send Email on Autonomous Database
- Send Slack Notifications from Autonomous Database
- Send Microsoft Teams Notifications from Autonomous Database
- User Defined Notification Handler for Scheduler Jobs
- Oracle Extensions for IDEs
- Use Oracle Java on Autonomous Database
-
Test Workloads with Oracle Real
Application Testing
- About Oracle Real Application Testing
- Capture-Replay Workloads between Autonomous Databases
- Capture-Replay Workloads between non-Autonomous and Autonomous Databases
- Test Workloads Against an Upcoming Patch
-
Manage and Store Files in a Cloud
Code Repository with Autonomous Database
- About Cloud Code Repositories with Autonomous Database
- Initialize a Cloud Code Repository
- Create and Manage a Cloud Code Repository
- Create and Manage Branches in a Cloud Code Repository
- Export Schema Objects to the Cloud Code Repository Branch
- Use File Operations with a Cloud Code Repository
- Use SQL Install Operations with a Cloud Code Repository
-
Invoke User Defined Functions
- About User Defined Functions
- Steps to Invoke OCI Cloud Functions as SQL Functions
- Steps to Invoke AWS Lambda as SQL Functions
- Steps to Invoke Azure Functions as SQL Functions
-
Invoke External Procedures as SQL Functions
- External Procedures Overview
- About Using External Procedures in Autonomous Database
- Define the C Procedure
- Create a Shared Library (.so) File
- Get the OCI Marketplace EXTPROC Stack Application
- Launch EXTPROC Stack Application
- Create Stack for EXTPROC Agent Application
- Upload Wallet to Create Secure Connection to the EXTPROC Agent Instance
- Steps to Invoke an External Procedure as a SQL Function
-
Make External Calls Using a
Customer-Managed Wallet
- About Using a Customer-Managed Wallet with External Calls
- Prerequisites to Use a Customer-Managed Wallet with External Calls
- Use a Customer-Managed Wallet for External Calls with UTL_HTTP
- Use a Customer-Managed Wallet with Scheduler Email Notifications
- Notes for Using a Customer-Managed Wallet with External Calls
- Use Cloud Tables to Store Logging and Diagnostic Information
-
Use APEX with Autonomous Database
-
Analyze
- Build Reports and Dashboards Using Oracle Analytics
- Create Dashboards, Reports, and Notebooks
- Spatial Analytics with Oracle Spatial
-
The Data Analysis Tool
- Searching and obtaining information about Analytic Views
- Creating Analytic Views
- Working with Analyses
- Viewing Analyses
- Workflow to build Analyses
- Creating Analyses
- Creating Reports
- Run Natural Language Query in the Data Analysis Tool
- Using Calculation Templates
-
Oracle Autonomous Database Add-in for Excel
- Install the add-in on Mac
- Install the add-in on Windows
- Uninstall the add-in
- Using Oracle Autonomous Database Add-in for Excel
- Connection management
- Import a Connection
- Add a connection
- Share a connection
- Run native SQL queries in an Excel worksheet
- Query an Analytic View in an Excel worksheet
- Data Analysis in Excel Sheet
- FAQs for Troubleshooting errors with Excel Add-in
-
Oracle Autonomous Database add-on for Google Sheets
- Install and setup the add-on for Google Sheets
- Download Connection File
- Connecting to Autonomous Database
- Generate Client ID and Client Secret using UI
- Authorize Google Sheets to use Autonomous Database
- Data Analysis in Google Sheets
- Generate SQL Queries from Natural Language using the add-on
- Run Direct SQL Queries
- Reporting and Analysis in Google Sheets
- Clear Sheet
- Delete all sheets
- About menu
- Sign Out
- Share or Publish
- Oracle Autonomous Database Privacy Policy Details
- The Catalog Page
- The Data Insights Page
- Use Oracle OLAP with Autonomous Database
-
Manage the Service
-
Lifecycle Operations
- Provision an Autonomous Database Instance
- Start Autonomous Database
- Stop Autonomous Database
- Restart Autonomous Database
- Rename Autonomous Database
- Update the Display Name for an Autonomous Database Instance
- Terminate an Autonomous Database Instance
- Undelete a Terminated Autonomous Database Instance
- Change Autonomous Database Operation Mode to Read/Write Read-Only or Restricted
- Schedule Start and Stop Times for an Autonomous Database Instance
- Concurrent Operations on Autonomous Database
- Updating Compute and storage limits
-
Update Billing Model, License
Type, or Update Instance to a Paid Instance
- Choose Your License and Oracle Database Edition While Provisioning or Cloning (ECPU Compute Model)
- View and Update Your License and Oracle Database Edition on Autonomous Database (ECPU Compute Model)
- View and Update Your License and Oracle Database Edition on Autonomous Database (OCPU Compute Model)
- Update to ECPU Billing Model on Autonomous Database
- Update Always Free Instance to Paid with Autonomous Database
- Upgrade Autonomous JSON Database to Autonomous Transaction Processing
- Upgrade APEX Service to Autonomous Transaction Processing
-
Clone and Move an Autonomous Database
- About Cloning on Autonomous Database
- Prerequisites for Cloning
- Clone an Autonomous Database Instance
- Clone an Autonomous Database from a Backup
- Cross Tenancy and Cross-Region Cloning
- Clone Autonomous Database to Change Workload Type
- Notes for Cloning Autonomous Database
- Move an Autonomous Database to a Different Compartment
- Upgrade an Autonomous Database Instance to Oracle Database 23ai
-
Use Refreshable Clones with Autonomous Database
-
About Refreshable Clones on
Autonomous Database
- Refreshable Clone Features
- Refreshable Clone Operations
- Refreshable Clone with Automatic Refresh Enabled
- Refreshable Clone Lifecycle States
- Refreshable Clone Refresh Timing and Disconnecting from the Source Database
- Refreshable Clone Reconnect to the Source Database
- Operations on an Autonomous Database with an Attached Refreshable Clone
- Prerequisites for Creating a Refreshable Clone
- Create a Refreshable Clone for an Autonomous Database Instance
- View Refreshable Clones for an Autonomous Database Instance
- Edit Automatic Refresh Policy for Refreshable Clone
- Refresh a Refreshable Clone on Autonomous Database
- Disconnect a Refreshable Clone from the Source Database
- Reconnect a Refreshable Clone to the Source Database
- Create a Cross Tenancy or Cross-Region Refreshable Clone
- Use the API
- Refreshable Clone Notes
-
About Refreshable Clones on
Autonomous Database
- Manage Autonomous Database Built-in Tools
- Use Autonomous Database Events
- Manage Time Zone File Updates on Autonomous Database
- Monitor Autonomous Database Availability
- Monitor Regional Availability of Autonomous Databases
-
Lifecycle Operations
- Manage and View Notifications
-
Monitor and Manage
Performance
- Monitor the Performance of Autonomous Database
- Monitor Autonomous Database with Performance Hub
-
Manage Concurrency and Priorities on Autonomous Database
- Database Service Names for Autonomous Database
- Idle Time Limits
-
Service Concurrency
- Service Concurrency Limits for Data Warehouse Workloads (ECPU Compute Model)
- Service Concurrency Limits for Transaction Processing Workloads (ECPU Compute Model)
- Service Concurrency Limits for Data Warehouse Workloads (OCPU Compute Model)
- Service Concurrency Limits for Transaction Processing and JSON Database Workloads (OCPU Compute Model)
- Change MEDIUM Service Concurrency Limit (ECPU Compute Model)
- Change MEDIUM Service Concurrency Limit (OCPU Compute Model)
- Predefined Job Classes with Oracle Scheduler
- Manage CPU/IO Shares on Autonomous Database
- Manage Runaway SQL Statements on Autonomous Database
- Use Fast Ingest on Autonomous Database
- Monitor the Performance of Autonomous Database with Oracle Management Cloud
- Monitor Performance with Autonomous Database Metrics
- Use Database Management Service to Monitor Databases
- Perform SQL Tracing on Autonomous Database
- Service Console Replacement with Database Actions
- Available Metrics: oci_autonomous_database
- Use Sample Data Sets in Autonomous Database
-
Use the Autonomous Database Free Container
Image
- About the Free Container Image
- Container Registry Locations for Autonomous Database Free Container Image
- Start Free Container Image
- Perform Database Operations using adb-cli
-
Connect to an Free Container Image
- Connect to ORDS, APEX, or Database Actions from an Autonomous Database Container Image
- Available TNS Aliases for Connecting to an Autonomous Database Container Image
- Connect to an Autonomous Database Container Image with a Wallet
- Connect to an Autonomous Database Container Image without a Wallet (TLS)
- Migrate Data Between Autonomous Database Free Containers
-
4
Tutorials
- Load and Analyze Your Data with Autonomous Database
- Self-service Tools for Everyone Using Oracle Autonomous Database
- Manage and Monitor Autonomous Database
- Integrate, Analyze and Act on All Data using Autonomous Database
- Load the Autonomous Database with Data Studio
- QuickStart Java applications with Autonomous Database
-
5
Features
- Data Lake Capabilities
- Data Studio
-
High Availability
-
Use Application Continuity on Autonomous Database
- About Application Continuity on Autonomous Database
- Configure Application Continuity on Autonomous Database
- Client Configuration for Continuous Availability on Autonomous Database
- Notes for Application Continuity on Autonomous Database
-
Use Standby Databases with Autonomous Data
Guard for
Disaster Recovery
-
About Standby Databases
- Autonomous Data Guard with Local Standby
-
Autonomous Data
Guard with Cross-Region
Standby
- Autonomous Data Guard Database Role
- Autonomous Data Guard Cross-Region Failover and Switchover
- Autonomous Data Guard Database Cross-Region Backup and Restore
- Cross-Region Disaster Recovery Connection Strings and Wallets
- Autonomous Data Guard with Customer Managed Keys
- Replicating Backups to a Cross-Region Autonomous Data Guard Standby
- Autonomous Data Guard Cross-Region BYOL Licensing
- Autonomous Data Guard Recovery Time Objective (RTO) and Recovery Point Objective (RPO)
- Autonomous Data Guard Operations
- Autonomous Database Disaster Recovery Status
- Autonomous Data Guard Events
- Enable Autonomous Data Guard
- Add a Cross-Region Standby Database
- Perform a Switchover
- Automatic Failover with a Standby Database
- Perform a Manual Failover
- Convert Cross-Region Peer to Snapshot Standby
- Update Standby to Use a Backup Copy Peer
- Disable a Cross-Region Standby Database
- Manage Remote Peer Network ACLs
- Events and Notifications for a Standby Database
-
Use a Cross Tenancy Autonomous Data
Guard Standby
Database
- About Cross Tenancy Autonomous Data Guard
- Prerequisites to Create a Cross Tenancy Autonomous Data Guard Standby
- Add a Cross Tenancy Autonomous Data Guard Standby
- Switchover, Failover, or Create a Snapshot Standby with a Cross Tenancy Autonomous Data Guard Standby
- Terminate a Cross Tenancy Autonomous Data Guard Standby
- Use the API
- Autonomous Data Guard Notes
- Autonomous Database Cross-Region Paired Regions
-
About Standby Databases
- Backup and Restore Autonomous Database Instances
- Use OraMTS Feature
-
Use Backup-Based Disaster
Recovery
- About Backup-Based Disaster Recovery
- View Backup-Based Disaster Recovery Peer
- Add a Cross-Region Disaster Recovery Peer
- Update Disaster Recovery Type
- Disable a Cross-Region (Remote) Peer
- Perform a Switchover to a Backup Copy Peer
- Perform a Failover
- Convert Cross-Region Backup-Based Disaster Recovery Peer to Snapshot Standby
- Update Remote Peer Network ACLs for a Backup-Based Disaster Recovery Peer
- Use the API
- Backup-Based Disaster Recovery Events
- Track Table Changes with Flashback Time Travel
- Use OCI Full Stack Disaster Recovery Service with Autonomous Database
-
Use Application Continuity on Autonomous Database
-
Security
- Security Features Overview
- Security and Authentication in Oracle Autonomous Database
- Security Testing Policies
-
Manage Encryption Keys on Autonomous Database
- About Master Encryption Key Management on Autonomous Database
- Prerequisites to Use Customer-Managed Encryption Keys on Autonomous Database
- Use Customer-Managed Encryption Keys with Vault Located in Local Tenancy
- Use Customer-Managed Encryption Key Located in a Remote Tenancy
- Switch to Oracle-Managed Encryption Keys on Autonomous Database
- View History for Customer-Managed Encryption Keys on Autonomous Database
-
Notes for Using Customer-Managed
Keys with Autonomous Database
- Caution for Customer-Managed Encryption Keys when Oracle Cloud Infrastructure Vault is Unreachable
- Caution for Using Customer-Managed Encryption Keys When the Master Key is Disabled or Deleted
- Caution for Using Customer-Managed Encryption Keys History and Backups
- Notes for Customer-Managed Keys with Autonomous Data Guard
- Notes for Customer-Managed Encryption Keys with Cloning
- Notes for Customer-Managed Keys with Vault in Remote Tenancy
-
Configure Network Access with Access Control Rules (ACLs) and Private Endpoints
- Configure Network Access with Access Control Rules
-
Configure Network Access with Private Endpoints
-
Configure Private
Endpoints
- Prerequisite Steps to Configure Private Endpoints
- IAM Policies Required to Manage Private Endpoints
- Configure Private Endpoints When You Provision or Clone an Instance
- Change from Public to Private Endpoints with Autonomous Database
- Update the Configuration for a Private Endpoint
- Configure Private Endpoint Advanced Options
- Use a Private Endpoint with Public Access Allowed
- Enhanced Security for Outbound Connections with Private Endpoints
- Private Endpoints Notes
- Private Endpoints Configuration Examples on Autonomous Database
-
Configure Private
Endpoints
- Update Network Options to Allow TLS or Require Only Mutual TLS (mTLS) Authentication on Autonomous Database
-
Audit Autonomous Database
- About Auditing Autonomous Database
- Register Oracle Data Safe on Autonomous Database
- Extend Audit Record Retention with Oracle Data Safe on Autonomous Database
- View and Manage Oracle Data Safe Audit Trails on Autonomous Database
- View and Manage Audit Policies with Oracle Data Safe on Autonomous Database
- Generate Audit Reports with Data Safe on Autonomous Database
- Rotate Wallets for Autonomous Database
-
Use Oracle Database Vault with
Autonomous Database
- Oracle Database Vault Users and Roles on Autonomous Database
- Enable Oracle Database Vault on Autonomous Database
- Disable Oracle Database Vault on Autonomous Database
- Disable User Management with Oracle Database Vault on Autonomous Database
- Enable User Management with Oracle Database Vault on Autonomous Database
- IAM Policies for Autonomous Database
- Use Oracle Data Safe
- Break Glass Access for SaaS on Autonomous Database
- Encrypt Data While Exporting or Decrypt Data While Importing
- Manage Oracle Cloud Operator Access
-
Performance Monitor and Management
- Use Operations Insights on Autonomous Database
- Manage Optimizer Statistics on Autonomous Database
- Manage Automatic Indexing on Autonomous Database
- Manage Automatic Partitioning on Autonomous Database
- Graph Analytics using Graph Studio
- Use Oracle Machine Learning with Autonomous Database
- Creating Analytic Views
-
Use Select AI for Natural
Language Interaction with your Database
- About Select AI
-
Select AI Concepts
- Actions
- AI Profile
- AI Provider
- Conversations
- Database Credential
- Hallucination in LLM
- IAM
- Large Language Model (LLM)
- Metadata
- Metadata Clone
- Natural Language Prompts
- Network Access Control List (ACL)
- Retrieval Augmented Generation (RAG)
- Similarity Search
- Synthetic Data Generation
- Vector Distances
- Vector Index
- Vector Store
- Select AI Use Cases
- Getting Started with Select AI
- Manage AI Profiles
- Use AI Keyword to Enter Prompts
- Select AI with Retrieval Augmented Generation (RAG)
-
Examples of Using Select
AI
- Example: Select AI Actions
- Example: Select AI with OpenAI
- Example: Select AI with Cohere
- Example: Select AI with Azure OpenAI Service
- Example: Select AI with OCI Generative AI
- Example: Select AI with Google
- Example: Set Up and Use Select AI with RAG
- Example: Improve SQL Query Generation with Table and Column Comments
- Example: Generate Synthetic Data
- Monitor and Troubleshoot Synthetic Data Generation
- JSON Document Stores
- Cache Messages with Singleton Pipes and Using Pipes for Persistent Messaging
- Full-Text Search Queries
- Use Oracle Workspace Manager on Autonomous Database
- Use and Manage Elastic Pools on Autonomous Database
- Migrate to Autonomous Database
- Use Database In-Memory with Autonomous Database
-
6
Reference
- Previous Feature Announcements
- Sample Star Schema Benchmark (SSB) Queries and Analytic Views
-
Autonomous Database Supplied Package Reference
-
DBMS_CLOUD Package
- DBMS_CLOUD Endpoint Management
-
DBMS_CLOUD Subprograms and REST APIs
- DBMS_CLOUD for Access Management
-
DBMS_CLOUD for Objects and Files
- COPY_COLLECTION Procedure
- COPY_DATA Procedure
- COPY_DATA Procedure for Avro, ORC, or Parquet Files
- COPY_OBJECT Procedure
- CREATE_CLOUD_TABLE Procedure
- CREATE_EXTERNAL_PART_TABLE Procedure
- CREATE_EXTERNAL_TABLE Procedure
- CREATE_EXTERNAL_TABLE Procedure for Apache Iceberg
- CREATE_EXTERNAL_TABLE Procedure for Avro, ORC, or Parquet Files
- CREATE_EXTERNAL_TEXT_INDEX Procedure
- CREATE_HYBRID_PART_TABLE Procedure
- DELETE_ALL_OPERATIONS Procedure
- DELETE_FILE Procedure
- DELETE_OBJECT Procedure
- DELETE_OPERATION Procedure
- DROP_EXTERNAL_TEXT_INDEX Procedure
- EXPORT_DATA Procedure
- GET_OBJECT Procedure and Function
- LIST_FILES Function
- LIST_OBJECTS Function
- MOVE_OBJECT Procedure
- PUT_OBJECT Procedure
- SYNC_EXTERNAL_PART_TABLE Procedure
- VALIDATE_EXTERNAL_PART_TABLE Procedure
- VALIDATE_EXTERNAL_TABLE Procedure
- VALIDATE_HYBRID_PART_TABLE Procedure
- DBMS_CLOUD for Bulk File Management
-
DBMS_CLOUD REST APIs
- DBMS_CLOUD REST API Overview
- DBMS_CLOUD REST API Constants
- DBMS_CLOUD REST API Results Cache
- GET_RESPONSE_HEADERS Function
- GET_RESPONSE_RAW Function
- GET_RESPONSE_STATUS_CODE Function
- GET_RESPONSE_TEXT Function
- GET_API_RESULT_CACHE_SIZE Function
- SEND_REQUEST Function and Procedure
- SET_API_RESULT_CACHE_SIZE Procedure
- DBMS_CLOUD REST API Examples
-
DBMS_CLOUD URI Formats
- Oracle Cloud Infrastructure Object Storage Native URI Format
- Oracle Cloud Infrastructure Object Storage Swift URI Format
- Oracle Cloud Infrastructure Object Storage URI Format Using Pre-Authenticated Request URL
- URI Format Using Public URL
- Oracle Cloud Infrastructure Object Storage Classic URI Format
- Amazon S3 URI Format
- Azure Blob Storage URI Format
- Amazon S3 Compatible URI Format
- GitHub Raw URL Format
- Additional Customer-Managed URI Formats
- DBMS_CLOUD Package Format Options
- DBMS_CLOUD Package Format Options for EXPORT_DATA
-
DBMS_CLOUD Avro, ORC, and Parquet Support
- DBMS_CLOUD Package Format Options for Avro, ORC, or Parquet
- DBMS_CLOUD Package Avro to Oracle Data Type Mapping
- DBMS_CLOUD Package ORC to Oracle Data Type Mapping
- DBMS_CLOUD Package Parquet to Oracle Data Type Mapping
- DBMS_CLOUD Package Oracle Data Type to Parquet Mapping
- DBMS_CLOUD Package Avro, ORC, and Parquet Complex Types
- DBMS_CLOUD Package Avro, ORC, and Parquet to Oracle Column Name Mapping
- DBMS_CLOUD Exceptions
-
DBMS_CLOUD_ADMIN Package
-
Summary of DBMS_CLOUD_ADMIN
Subprograms
- ATTACH_FILE_SYSTEM Procedure
- CANCEL_WORKLOAD_CAPTURE Procedure
- CREATE_DATABASE_LINK Procedure
- DETACH_FILE_SYSTEM Procedure
- DISABLE_APP_CONT Procedure
- DISABLE_EXTERNAL_AUTHENTICATION Procedure
- DISABLE_FEATURE Procedure
- DISABLE_OPERATOR_ACCESS Procedure
- DISABLE_PRINCIPAL_AUTH Procedure
- DISABLE_RESOURCE_PRINCIPAL Procedure
- DROP_DATABASE_LINK Procedure
- ENABLE_APP_CONT Procedure
- ENABLE_AWS_ARN Procedure
- ENABLE_EXTERNAL_AUTHENTICATION Procedure
- ENABLE_FEATURE Procedure
- ENABLE_OPERATOR_ACCESS Procedure
- ENABLE_PRINCIPAL_AUTH Procedure
- ENABLE_RESOURCE_PRINCIPAL Procedure
- FINISH_WORKLOAD_CAPTURE Procedure
- PREPARE_REPLAY Procedure
- PURGE_FLASHBACK_ARCHIVE Procedure
- REPLAY_WORKLOAD Procedure
- SET_FLASHBACK_ARCHIVE_RETENTION Procedure
- START_WORKLOAD_CAPTURE Procedure
- DBMS_CLOUD_ADMIN Exceptions
-
Summary of DBMS_CLOUD_ADMIN
Subprograms
-
DBMS_CLOUD_AI Package
-
Summary of DBMS_CLOUD_AI
Subprograms
- CREATE_PROFILE Procedure
- DROP_PROFILE Procedure
- ENABLE_PROFILE Procedure
- DISABLE_PROFILE Procedure
- GET_PROFILE Function
- GET_PROFILE Procedure
- SET_ATTRIBUTE Procedure
- SET_PROFILE Procedure
- GENERATE Function
- GENERATE_SYNTHETIC_DATA Function
- Profile Attributes
- CREATE_VECTOR_INDEX Procedure
- DROP_VECTOR_INDEX Procedure
- DISABLE_VECTOR_INDEX Procedure
- ENABLE_VECTOR_INDEX Procedure
- UPDATE_VECTOR_INDEX Procedure
- Vector Index Attributes
-
Summary of DBMS_CLOUD_AI
Subprograms
- DBMS_CLOUD_FUNCTION Package
- DBMS_CLOUD_LINK Package
- DBMS_CLOUD_LINK_ADMIN Package
- DBMS_CLOUD_MACADM Package
- DBMS_CLOUD_MIGRATION Package
- DBMS_CLOUD_NOTIFICATION Package
- DBMS_CLOUD_PIPELINE Package
-
DBMS_CLOUD_REPO Package
- DBMS_CLOUD_REPO Overview
- DBMS_CLOUD_REPO Data Structures
- DBMS_CLOUD_REPO Subprogram Groups
-
Summary of DBMS_CLOUD_REPO
Subprograms
- CREATE_BRANCH Procedure
- CREATE_REPOSITORY Procedure
- DELETE_BRANCH Procedure
- DELETE_FILE Procedure
- DELETE_REPOSITORY Procedure
- EXPORT_OBJECT Procedure
- EXPORT_SCHEMA Procedure
- GET_FILE Procedure and Function
- INIT_AWS_REPO Function
- INIT_AZURE_REPO Function
- INIT_GITHUB_REPO Function
- INIT_REPO Function
- INSTALL_FILE Procedure
- INSTALL_SQL Procedure
- LIST_BRANCHES Function
- LIST_COMMITS Function
- LIST_FILES Function
- LIST_REPOSITORIES Function
- MERGE_BRANCH Procedure
- PUT_FILE Procedure
- UPDATE_REPOSITORY Procedure
- DBMS_AUTO_PARTITION Package
- DBMS_DATA_ACCESS Package
-
DBMS_DCAT Package
- Data Catalog Users and Roles
- Required Credentials and IAM Policies
- Summary of Connection Management Subprograms
- Summary of Synchronization Subprograms
-
Summary of Data Catalog Views
- ALL_CLOUD_CATALOG_DATABASES View
- ALL_CLOUD_CATALOG_TABLES View
- ALL_DCAT_ASSETS View
- ALL_DCAT_ATTRIBUTES View
- ALL_DCAT_CONNECTIONS View
- ALL_DCAT_ENTITIES View
- ALL_DCAT_FOLDERS View
- ALL_DCAT_GLOBAL_ACCESSIBLE_CATALOGS View
- ALL_DCAT_LOCAL_ACCESSIBLE_CATALOGS View
- ALL_GLUE_DATABASES View
- ALL_GLUE_TABLES View
- DCAT_ATTRIBUTES View
- DCAT_ENTITIES View
- DBMS_DCAT$SYNC_LOG View
- DBMS_INMEMORY_ADMIN Package
- DBMS_MAX_STRING_SIZE Package
- DBMS_PIPE Package
-
DBMS_SHARE Package
-
Summary of Share Producer
Subprograms
- ADD_TO_SHARE Procedure
- ASSERT_SHAREABLE_OBJECT Procedure
- ASSERT_SHARING_ID Procedure
- CAN_CREATE_SHARE Function
- CAN_CREATE_SHARE_RECIPIENT Function
- CLEAR_RECIPIENT_EVENTS Procedure
- CLEAR_SHARE_EVENTS Procedure
- CREATE_BEARER_TOKEN_CREDENTIAL Procedure
- CREATE_CLOUD_STORAGE_LINK Procedure
- CREATE_OR_REPLACE_CLOUD_STORAGE_LINK Procedure
- CREATE_OR_REPLACE_SHARE_RECIPIENT Procedure
- CREATE_SHARE Procedure
- CREATE_SHARE_RECIPIENT Procedure
- DROP_CLOUD_STORAGE_LINK Procedure
- DROP_RECIPIENT Procedure
- DROP_SHARE Procedure
- DROP_SHARE_LINK_VIEW Procedure
- DROP_SHARE_VERSION Procedure
- DROP_SHARE_VERSIONS Procedure
- DROP_UNUSED_SHARE_VERSIONS Procedure
- ENABLE_SCHEMA Procedure
- GET_ACTIVATION_LINK Function
- GET_PUBLISHED_IDENTITY Function
- GET_RECIPIENT_PROPERTY Function
- GET_SHARE_PROPERTY Function
- GET_SHARE_TABLE_PROPERTY Function
- GRANT_TO_RECIPIENT Procedure
- POPULATE_SHARE_PROFILE Procedure
- PUBLISH_SHARE Procedure
- PUBLISH_SHARE_WAIT Procedure
- PURGE_DETACHED_FILES Procedure
- REMOVE_FROM_SHARE Procedure
- RENAME_RECIPIENT Procedure
- RENAME_SHARE Procedure
- RENAME_SHARE_LINK Procedure
- RENAME_SHARE_SCHEMA Procedure
- RENAME_SHARE_TABLE Procedure
- REVOKE_FROM_RECIPIENT Procedure
- SET_CURRENT_SHARE_VERSION Procedure
- SET_PUBLISHED_IDENTITY Procedure
- SET_RECIPIENT_LOG_LEVEL Procedure
- SET_SHARE_LOG_LEVEL Procedure
- SET_STORAGE_CREDENTIAL Procedure
- STOP_JOB Procedure
- UNPUBLISH_SHARE Procedure
- UPDATE_DEFAULT_RECIPIENT_PROPERTY Procedure
- UPDATE_DEFAULT_SHARE_PROPERTY Procedure
- UPDATE_RECIPIENT_PROPERTY Procedure
- UPDATE_SHARE_JOB_PROPERTY Procedure
- UPDATE_SHARE_PROPERTY Procedure
- UPDATE_SHARE_TABLE_PROPERTY Procedure
- VALIDATE_CREDENTIAL Function
- VALIDATE_SHARE_STORAGE Procedure
- WAIT_FOR_JOB Procedure
-
Summary of Share Consumer
Subprograms
- ASSERT_SHARING_ID Procedure
- CREATE_CREDENTIALS Procedure and Function
- CREATE_OR_REPLACE_SHARE_LINK Procedure
- CREATE_OR_REPLACE_ORACLE_SHARE_PROVIDER Procedure
- CREATE_ORACLE_SHARE_PROVIDER Procedure
- CREATE_SHARE_LINK Procedure
- CREATE_SHARE_LINK_VIEW Procedure
- CREATE_SHARE_PROVIDER Procedure
- DISCOVER_AVAILABLE_SHARES Function
- DISCOVER_AVAILABLE_TABLES Function
- DROP_SHARE_LINK Procedure
- DROP_SHARE_PROVIDER Procedure
- ENABLE_DELTA_ENDPOINT Procedure
- FLUSH_SHARE_LINK_CACHE Procedure
- FLUSH_SHARE_PROVIDER_CACHE Procedure
- GENERATE_SHARE_LINK_SELECT Procedure and Function
- GET_ORACLE_SHARE_LINK_INFO Function
- GET_SHARE_LINK_INFO Procedure
- GET_SHARE_PROVIDER_CREDENTIAL Procedure
- GET_SHARE_PROVIDER_INFO Procedure
- GET_SHARING_ID Function
- OPEN_SHARE_LINK_CURSOR Procedure
- REFRESH_BEARER_TOKEN_CREDENTIAL Procedure
- RENAME_CLOUD_STORAGE_LINK Procedure
- RENAME_SHARE_PROVIDER Procedure
- REMOVE_SHARE_SCHEMA Procedure
- SET_SHARE_LINK_METADATA Procedure
- SET_SHARE_PROVIDER_CREDENTIAL Procedure
- SET_SHARE_PROVIDER_METADATA Procedure
- UPDATE_BEARER_TOKEN_CREDENTIAL Procedure
-
Summary of Share Producer
Views
- ALL_OBJECT_SHAREABILITY View
- ALL_SHAREABLE_OBJECTS View
- ALL_SHARES View
- ALL_SHARE_DEFAULT_SETTINGS View
- ALL_SHARE_EVENTS View
- ALL_SHARE_FILES View
- ALL_SHARE_RECIPIENTS View
- ALL_SHARE_RECIPIENT_EVENTS View
- ALL_SHARE_RECIPIENT_GRANTS View
- ALL_SHARE_SCHEMAS View
- ALL_SHARE_TABLES View
- ALL_SHARE_VERSIONS View
- DBA_SHARE_DETACHED_FILES View
- DBA_SHARE_EVENTS View
- DBA_SHARE_FILES View
- DBA_SHARE_JOB_SEGMENTS View
- DBA_SHARE_JOBS View
- DBA_SHARE_RECIPIENT_EVENTS View
- DBA_SHARE_RECIPIENT_GRANTS View
- DBA_SHARE_RECIPIENTS View
- DBA_SHARE_SCHEMAS View
- DBA_SHARE_TABLES View
- DBA_SHARE_VERSIONS View
- DBA_SHARES View
- USER_SHARE_DETACHED_FILES View
- USER_SHARE_EVENTS View
- USER_SHARE_FILES View
- USER_SHARE_JOBS View
- USER_SHARE_JOB_SEGMENTS View
- USER_SHARE_RECIPIENT_EVENTS View
- USER_SHARE_RECIPIENT_GRANTS View
- USER_SHARE_RECIPIENTS View
- USER_SHARE_SCHEMAS View
- USER_SHARE_TABLES View
- USER_SHARE_VERSIONS View
- USER_SHAREABLE_OBJECTS View
- USER_SHARES View
- Summary of Share Consumer Views
- DBMS_SHARE Constants
-
Summary of Share Producer
Subprograms
- CS_RESOURCE_MANAGER Package
- CS_SESSION Package
-
DBMS_CLOUD Package
-
Autonomous Database for Experienced Oracle Database Users
- About Autonomous Database for Experienced Oracle Database Users
-
Autonomous Database Views
- Track Table and Partition Scan Access with Autonomous Database Views
- Track Oracle Cloud Infrastructure Resources, Cost and Usage Reports with Autonomous Database Views
- Pipeline Views
- DBMS_CLOUD_AI Views
- DBMS_CLOUD_FUNCTION Views
- DBMS_CLOUD_LINK Views
- DBMS_DATA_ACCESS Views
- Oracle Cloud Infrastructure Logging Interface Views
- Real Application Testing Capture Replay Views
- Stripe Views on Autonomous Database
- Track DBMS_CLOUD Load Operations
- Autonomous Database – Oracle Database Features
- Autonomous Database with Oracle Database 23ai
- Autonomous Database RMAN Recovery Catalog
- Notes for Users Migrating from Other Oracle Databases
- Database Features Unavailable in Autonomous Database
-
Logical Partition Change Tracking and Materialized Views
- About Logical Partition Change Tracking
-
Using Logical Partition Change Tracking
- Creating Logical Partitions - BNF
- Choosing the Logical Partition Key Column
- Freshness of Materialized Views Using Logical Partition Change Tracking
- Rewrite with Materialized Views Using Logical Partition Change Tracking
- Refresh of Materialized Views Using Logical Partition Change Tracking
- Logical Partition Change Tracking – Data Dictionary Views
- Example: Logical Partition Change Tracking
- Migrating MySQL and Third-Party Databases to Autonomous Database
- SODA Collection Metadata
-
Cloud Support and Identity Information
-
Obtain Tenancy Details
- Database Name
- Region
- Tenancy OCID
- Database OCID
- Compartment OCID
- Outbound IP Address
- Public Domain Name
- Tenant Account Name
- Autoscalable Storage
- Base Size
- Infrastructure
- Service
- Applications
- Availability Domain
- Compute Model
- Compute Count
- Compute Auto Scaling
- Cloud Identity Information for Autonomous Data Guard
- Public IP Address Ranges for Autonomous Database
-
Obtain Tenancy Details