Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
• 1 Changes in This Release
• 2 About Oracle Database Actions
  • Accessing Database Actions
    • Enabling User Access to Database Actions
  • About the Database Actions User Interface
    • Using the Omnisearch Bar
  • The Home Page - Launchpad
  • Enabling Detailed Request Error Messages for a Specific Schema
• Part I Development
  • 3 The SQL and Data Modeler Pages
    • The Overview Page
    • The SQL Page
      • Object Navigator and Files
      • Executing SQL Statements in the Code Editor
        • About Session State in Database Actions
        • Keyboard Shortcuts
        • Support for Multilingual Engine
      • Viewing the SQL Output
        • Using the Explain Plan Diagram
      • Loading Data
        • Loading Data from a Local File to a New Table
        • Loading Data from a Local File to an Existing Table
        • Loading Data from Multiple Local Files into Mutiple Tables
    • The Data Modeler Page
      • Navigating Diagrams and Objects
      • About the Data Modeler Editor
        • About Viewing JSON Data Guides
    • Creating and Editing Database Objects
      • The Table Properties Dialog
        • Columns Pane
        • Primary Key Pane
        • Unique Keys Pane
        • Indexes Pane
        • Foreign Keys Pane
        • Table Constraints Pane
        • Comments Pane
        • Storage Pane
        • External Table Properties Pane
        • Materialized View Pane
        • DDL Pane
        • Output Pane
      • The Index Properties Dialog
      • The Sequence Properties Dialog
      • The View Properties Dialog
      • The Synonym Properties Dialog
      • The Materialized View Log Properties Dialog
      • Implied Foreign Keys
  • 4 The REST Pages
    • About RESTful Web Services
    • RESTful Services Terminology
    • About the Overview Page
    • About the AutoREST Page
      • Enabling REST Access for a Database Object
      • Disabling REST Access for a Database Object
      • Generating cURL Requests for a REST-Enabled Database Object
    • About the REST Search Toolbar
    • Creating RESTful Web Services
      • Managing Resource Modules
        • Creating a Resource Module
        • Importing a Resource Module
        • Editing a Resource Module
        • Deleting a Resource Module
        • Publishing/Unpublishing a Resource Module
        • Exporting a Resource Module
        • Viewing the Module in OpenAPI View
      • Managing Resource Templates
        • Creating a Resource Template
        • Editing a Resource Template
        • Deleting a Resource Template
      • Managing Resource Handlers
        • Creating a Resource Handler
        • Editing a Resource Handler
        • Deleting a Resource Handler
        • Viewing Resource Handler Details and Managing Parameters
          • Creating a Parameter
          • Editing a Parameter
          • Deleting a Parameter
          • Implicit Parameters
        • Using Pre-Authenticated Requests to Access ORDS RESTful Services
          • Creating a Pre-Authenticated Request
          • Viewing a Pre-Authenticated Request
          • Revoking a Pre-Authenticated Request
      • Example: Inserting a Record using a POST Handler
    • Securing RESTful Web Services
      • Managing Roles
        • Creating a Role
        • Editing a Role
        • Deleting a Role
        • Viewing Assigned Privileges
      • Managing Privileges
        • Creating a Privilege
        • Editing a Privilege
        • Deleting a Privilege
      • Managing OAuth Clients
        • Creating an OAuth Client
        • Editing an OAuth Client
        • Deleting an OAuth Client
        • Exporting an OAuth Client
        • Managing Secrets
      • Examples
        • Creating an OAuth Client Using the Client Credentials Grant Type
        • Creating an OAuth Client Using the Auth Code Grant Type
  • 5 The JSON Page
    • About the JSON User Interface
    • Managing JSON Collections
      • Creating a Collection
      • About Adding or Editing a JSON Document
        • About Database Differences in JSON Documents
    • About Querying Documents in a Collection
      • Using the In-Context Autocomplete Feature in the JSON Editor
    • Creating Indexes for JSON Collections
    • Creating Relational Views of JSON Documents
    • Viewing the JSON Data Guide Diagram for a Collection
  • 6 The Charts and Dashboards Page
    • Overview
    • Creating or Editing a Chart
    • Example: Creating and Editing a Chart
    • Creating or Editing a Dashboard
  • 7 The Scheduling Pages
    • Overview
    • Jobs
      • Summary
      • Running
      • History
      • Forecast
      • History (Gantt Chart)
      • Notifications
      • Create or Edit Job
    • Chains
      • Create or Edit Chain
      • Add or Edit Step
      • Add or Edit Rule
    • Programs
      • Create or Edit Program
    • Schedules
      • Create or Edit Schedule
    • Objects
      • Create Job Class
      • Create File Watcher
      • Create Window
      • Create Window Group
  • 8 The Liquibase Page
    • Generate a Deployment
    • About the Liquibase User Interface
• Part II Vector Database
• Part III Monitoring
  • 9 The Monitoring Pages
    • The Monitoring Overview Page
    • The Performance Hub Page
    • The Alerts Page
    • The Sessions Page
    • The Storage Page
    • The Parameters Page
    • The Database Dashboard Page
      • Database Dashboard Overview
      • Database Dashboard Activity
    • The AWR Page
• Part IV Administration
  • 10 The Database Users Page
    • Creating or Editing a User
    • Enabling REST
    • Deleting a User
  • 11 The APEX Workspaces Page
    • Create a Workspace
  • 12 The Data Pump Page
    • Importing Data using Oracle Data Pump
      • Requirements
      • Importing Data
• Part V Data Tools
  • 13 The Data Studio Overview Page
  • 14 Python Data Studio API for Oracle Autonomous Database
    • Working with Python Data Studio API for Autonomous Database
      • Ingest Functions
      • Analytic View Functions
      • Insight Functions
      • Miscellaneous functions
      • Data Share Functions
        • Recipient Data Share Functions
        • Provider Data Share Functions
      • Catalog Functions
  • 15 The Data Load Page
    • Data Studio Settings
      • Slack Integration with Data Studio
      • About AI Profiles
        • Create an AI Profile
        • Manage AI Profiles
    • Managing Connections
      • Register Data Catalog
      • Create Credentials
      • Create Oracle Cloud Infrastructure Native Credentials
      • Create Amazon Web Services (AWS) Credentials
      • Manage Resource Principal with DBMS_CLOUD
    • Loading Data
      • Use OCI Language Service Capabilities in Data Studio
        • Overview of Sentiment Analysis, Key Phrase Extraction and Language Detection
        • Parameters to Analyze Data
        • Perform Sentiment Analysis
          • Output Data Generated from OCI Sentiment Analysis
        • Perform Key Phrase Extraction
          • Output Data Generated from OCI Key Phrase Extraction
        • Perform Language Detection
          • Output Data Generated from OCI Language Detection
        • Perform Text Translation
          • Output Data Generated from OCI Text Translation
      • Use OCI Document Understanding to extract Tables from Images
        • Overview of Table Extraction
        • Perform Table Extraction from Image
      • Use GeoJSON in Data Load
        • Add Spatial Expression for GeoJSON columns
        • Parameters for Spatial Data Analysis
        • Perform Spatial Analysis
        • Output Data Generated from Spatial Analysis
      • Loading Data From Local Files
      • Loading Data from Other Databases
        • Load Data from Oracle and Non-Oracle Databases using Database Links
      • Loading Data from Cloud Storage
        • Manage Cloud Storage Links for Data Load Jobs
        • Prepare the Data Load Job
        • Add Files or Folders for the Data Load Job
        • Enter Details for the Data Load Job
        • Run the Data Load Job
        • View Details About the Data Load Job After It Is Run
        • View the Table Resulting from the Data Load Job
      • Load Apache Iceberg Tables
      • Loading Data from File System
        • Create Directories in Database Actions
      • Loading Data from AI Source
      • Loading Data from Share
      • Create Live Feed from Data Load
    • Linking Data
      • Linking to Other Databases
      • Linking to Objects in Cloud Storage
        • Manage Cloud Storage Links for Data Link Jobs
        • Prepare the Data Link Job
        • Add Files or Folders for the Data Link Job
        • Enter Details for the Data Link Job
        • Run the Data Link Job
        • View Details About the Data Link Job After It Is Run
        • View the Table Resulting from the Data Link Job
      • Linking to File System
      • Linking to Share
      • Linking to Data Catalog
    • Feeding Data
      • Creating a Notification-Based Live Table Feed
      • Creating a Notification-Based Live Table Feed using Amazon Simple Storage Service (S3)
      • Creating a Notification-Based Live Table Feed using Microsoft Azure
      • Send Email using Live Feed Tool
    • DBMS_LIVE_FEED Package Reference
      • Summary of DBMS_LIVE_FEED Subprograms
  • 16 The Catalog Tool
    • About the Catalog Page
    • Browse and Search Catalogs
    • Sorting and Filtering Entities
    • Filter Entities
    • Display Entity Search
    • Catalog Settings
    • Metadata Enrichment
    • Manage Catalogs
      • Manage Catalog Cache
      • Inline Data Load of Delta Share from the Catalog Tool
      • Query Remote Catalogs and Databases
        • Conceptual Diagram of Querying Remote Catalogs
        • Concepts related to querying remote catalogs and databases
        • About Querying Remote Catalogs and Databases
        • Examples: List the Mounted Catalogs
        • Examples: List the Tables in a Catalog, Including Their Owning Schemas
        • Examples: Query Data from a Table in a Catalog
        • Examples: Query a Table from a Delta Share and Analyze the View
    • Viewing Entity Details
      • Autonomous Database Entity Details
    • Register to Cloud Links for Accessing Data
    • Export Data to Cloud
    • Gathering Statistics for Tables
    • Editing Tables
      • Columns Pane
      • Primary Key Pane
      • Unique Keys Pane
      • Indexes Pane
      • Foreign Keys Pane
      • Table Constraints Pane
      • Comments Pane
      • Storage Pane
      • External Table Properties Pane
      • Materialized View Pane
      • DDL Pane
      • Output Pane
    • Manage Catalogs with DBMS_CATALOG
      • DBMS_CATALOG Package
      • Summary of DBMS_CATALOG
        • MOUNT_DATA_CATALOG Procedure
        • MOUNT_DB_LINK Procedure
        • MOUNT_ICEBERG Procedure
        • MOUNT_SHARE Procedure
        • MOUNT_SHARES Procedure
        • MOUNT_VIRTUAL_CATALOG Procedure
        • UNMOUNT Procedure
        • GET_CATALOG_PROPERTY Procedure
        • GET_CATALOG_PROPERTY_CLOB Procedure
        • UPDATE_CATALOG_PROPERTY Procedure
        • UPDATE_CATALOG_PROPERTY_CLOB Procedure
        • GET_COLUMN_PROPERTY Function
        • GET_COLUMN_PROPERTY_CLOB Function
        • UPDATE_COLUMN_PROPERTY Procedure
        • UPDATE_COLUMN_PROPERTY_CLOB Procedure
        • GET_SCHEMA_PROPERTY Procedure
        • GET_SCHEMA_PROPERTY_CLOB Procedure
        • UPDATE_SCHEMA_PROPERTY Procedure
        • UPDATE_SCHEMA_PROPERTY_CLOB Procedure
        • GET_TABLE_PROPERTY Procedure
        • GET_TABLE_PROPERTY_CLOB Procedure
        • UPDATE_TABLE_PROPERTY Procedure
        • UPDATE_TABLE_PROPERTY_CLOB Procedure
        • ADD_REQUIRED_CREDENTIAL Procedure
        • REMOVE_REQUIRED_CREDENTIAL Procedure
        • RENAME_REQUIRED_CREDENTIAL Procedure
        • GET_REQUIRED_CREDENTIAL_PROPERTY Procedure
        • UPDATE_REQUIRED_CREDENTIAL_PROPERTY Procedure
        • GET_LOCAL_CREDENTIAL_MAP (Overloaded) Procedure
        • SET_LOCAL_CREDENTIAL Procedure
        • GET_CLOUD_STORAGE_LINK_PROPERTY Function
        • GET_CLOUD_STORAGE_LINK_PROPERTY_CLOB Function
        • UPDATE_CLOUD_STORAGE_LINK_PROPERTY Procedure
        • UPDATE_CLOUD_STORAGE_LINK_PROPERTY_CLOB Procedure
        • CREATE_CLOUD_STORAGE_LINK Procedure
        • DROP_CLOUD_STORAGE_LINK Procedure
        • GET_CLOUD_STORAGE_LINKS Function
        • GET_COLUMNS Function
        • CREATE_EXTERNAL_TABLE Procedure
        • CREATE_SCHEMA Procedure
        • DROP_SCHEMA Procedure
        • GET_OBJECTS Procedure
        • GET_SCHEMAS Procedure
        • GET_TABLES Procedure
        • GET_TABLE Procedure
        • GET_TABLE Function
        • DROP_TABLE Procedure
        • GENERATE_TABLE_SELECT (Overloaded) Procedure
        • OPEN_TABLE_CURSOR Procedure
        • FLUSH_CATALOG_CACHE Procedure
        • PREFILL_CATALOG_CACHE Procedure
        • CREATE_SYNCHRONIZED_SCHEMAS Procedure
        • DROP_SYNCHRONIZED_SCHEMAS Procedure
        • UPDATE_SYNCHRONIZED_SCHEMA_PROPERTY Procedure
        • SYNCHRONIZE_SHARED_CATALOGS Procedure
        • CREATE_SYNCHRONIZED_VIEWS Procedure
        • COPY_TABLE_PROPERTIES Procedure
        • GRANT_TO_RECIPIENT Procedure
        • REVOKE_FROM_RECIPIENT Procedure
        • CLEAR_CATALOG_EVENTS Procedure
        • CREATE_ICEBERG_TABLE Procedure
        • ADD_ICEBERG_SNAPSHOT Procedure
  • 17 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 an Apache Iceberg Connection
      • Create a Delta Share Connection
      • Create an Oracle Business Intelligence Cloud Connector Connection
      • Create and use an Oracle Cloud Infrastructure Generative AI Connection
      • Create an Oracle Enterprise Resource Planning Cloud 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 and Run Data Loads
      • Create a Data Load
      • Run a Data Load
    • Work with Data Entities
      • Import Data Entities
      • Create Data Entities
      • Create Data Entities within the Data Flow editor
      • View Statistics of Data Entities
    • Work with Projects
    • About Data Flows
      • Create a Data Flow
      • About Data Flow Editor
      • Supported Database Functions
      • Add Components
      • Use Text Embedding Vector in a Data Flow
      • Component Properties
      • Map Data Columns
      • Validate and Execute a Data Flow
    • Schedule Data Flows or Workflows
    • Monitor Status of Data Loads, Data Flows, and Workflows
    • Introduction to Workflows
      • Create a New Workflow
        • Define a Data Studio Data Load in a Work Flow
    • Create and Use Variables
      • Create a Variable
      • Use Variables in a Data Flow
      • Use Variables in a Workflow
    • Use Machine Learning (ML) Models
      • Create an ML Model Data Entity in the Data Flow editor
      • ML Model Data Entity Properties
      • Use ML Model in a Data Flow
    • Create and Manage Jobs
    • Export and Import Objects
      • Export Objects
      • Import Objects
    • Reference
      • Enable Access to Private Data Sources from Autonomous Database
      • Troubleshoot Mismatch with Server Cert DN Error
      • Increase the Memory of ODI Agent
  • 18 The Data Insights Page
    • About Insights
    • Generate Insights and View Reports
  • 19 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
      • Saving Analyses
    • Creating Reports
      • Working with Reports
      • Creating Reports on a Query
      • Creating Reports on an Analytic View
    • Run Natural Language Query in the Data Analysis Tool
      • Generate SQL Queries From Natural Language on Analytic Views
      • Generate SQL Queries from Natural Language on Tables
    • Generate Natural Language explanation from SQL Query using AI Explain
    • Vector Search in the Data Analysis Tool
    • Format Numeric Columns in the Data Analysis Tool
    • Using Calculation Templates
      • Cumulative Aggregates
      • Prior and Future Period
      • Period to Date
      • Parallel Period
      • Moving Aggregates
      • Share
      • Rank
    • Use Oracle Database for Spreadsheet Add-ins
      • About Oracle Database for Spreadsheet Add-ins
        • Privacy Policies and Contact Details
      • Installation Options for Spreadsheet Add-ins
        • Download Spreadsheet Add-ins from Database Actions
        • Install Add-in for Microsoft Excel from Trusted Catalogs
        • Install Add-in for Excel from Office Store
        • Install Add-on for Google Sheets from Google Workspace Marketplace
      • Connect to Autonomous AI Database from a Spreadsheet
      • Manage Connections
      • Access the Spreadsheet Add-in by OCI IAM Domains
      • Use Role-Based Access Control for IAM Authentication
        • Configure Role-Based Access Control Manually
        • Set up Role-Based Access Control Automatically using a Script
      • Using Spreadsheet Add-ins Features
        • UI Options in Spreadsheet Add-ins
        • Run Natural Language Queries
        • Run Direct SQL Queries
        • Perform Data Analysis using Spreadsheet Add-ins
        • Access and Share Data using Table Hyperlinks
      • Manage Settings
      • Remove Spreadsheet Add-ins
      • Troubleshoot Scenarios with Spreadsheet Add-ins
  • 20 The Data Marketplace Tool
    • Access Data Marketplace Tool
    • Publish Listings to Marketplace
    • Consume Dataset
    • DBMS_DATAMART Package Reference
      • Summary of DBMS_DATAMART Subprograms
  • 21 The Table AI Assist Tool
    • Prepare Data Using Table AI Assist Tool
      • Add a Column
      • Replace a Column
      • Remove a Column
      • Rename a Column
      • View Statistical Details about the Table you Load after you Create a Recipe
    • View Table Entity Details
    • Conversational AI for the Table AI Assist Tool
  • 22 The Jobs Feature
    • How to Access the Jobs Feature?
    • Conceptual Diagram of the Jobs Feature
    • Create a Job
    • Manage and Monitor the Job
    • DBMS_DATA_TOOLS_JOBS Package Reference
      • Summary of DBMS_DATA_TOOLS_JOB Subprograms
  • 23 The Data Share Tool
    • Overview of the Data Share Tool
    • Access and Enable the Data Share Tool
    • Provide Share
      • Provide Share Overview
      • Provide Versioned Share
      • Provide Live Share
      • View Share Entity Details
      • Create Share Recipient
      • View Share Recipient Entity Details
    • Consume Share
      • Consume Share Overview
      • Consume Versioned Share
      • Enable File-Level Change Data Feed Access for Versioned Shares
      • Consume Live Share
      • View Share Provider Entity Details
      • Sharing Databricks Tables with Deletion Vectors
    • Manage Shares with DBMS_SHARE
    • Data Share Limitations on Autonomous AI Database
    • Troubleshooting Errors with the Data Share Tool
      • Live Share Feature Slow Performance
      • Shared Table Query Attempt Failure
      • HTTP 403 Unauthorized Due to Remote IP Allowlist
    • FAQs on the Data Share Tool
• A Supported SQL*Plus and SQLcl Commands in SQL Worksheet
  • Supported SQL*Plus Commands
  • Supported SQLcl Commands
    • SODA Commands