Share and Consume Data with Data Share in Autonomous AI Database

Use Data Share in Data Studio to share Oracle data and metadata from Autonomous AI Database with other databases and non-database tools. Data Share supports provider and consumer workflows: a provider creates a share, adds objects and recipients, and publishes the share; a consumer subscribes to the provider and creates database objects that make the shared data available for querying.

This topic provides an entry point for understanding when and how to use Data Share with Autonomous AI Database. For detailed overview of the Data Share page and the available sharing types, see the Data Studio Documentation.

When to use Data Share

Use Data Share when you want a governed way to make data available to other users, databases, applications, or tools without building a custom export-and-delivery process.

For example, use it to:

Provide a share when your Autonomous AI Database contains tables or views that other teams, databases, or tools need to access.
Consume a share when another provider has made data available to your Autonomous AI Database.
Share versioned data when recipients should see a published snapshot and receive changes only when the provider publishes a new version.
Share live data when Autonomous AI Database recipients need access to the latest committed source data through a direct database connection.
Use open Delta Sharing-based access for tools and APIs that support Delta Sharing, or use Live Share for near-real-time access between supported Autonomous AI Database instances.
Automate sharing workflows with the DBMS_SHARE PL/SQL package when you want to implement provider or consumer process using scripts instead of the Data Studio UI.

How Data Share works with Autonomous AI Database

Data Share runs from Database Actions for Autonomous AI Database. Database Actions is bundled with each Autonomous AI Database instance and provides development, data, administration, monitoring, and download features. For non-ADMIN users, Database Actions hides tool cards when the user does not have the required permissions; Data Studio tools require the DWROLE database role. See Connect with Built-In Oracle Database Actions for more details.

Data Share has two primary roles:

Role	What the role does
Provider	Creates shares, selects database objects to share, registers recipients, publishes the share, manages versions or live access, and revokes or updates access when needed.
Consumer	Subscribes to a share provider, registers available shares, creates external tables or views for the shared objects, and queries the shared data from Autonomous AI Database.

A Versioned Share publishes data as a known snapshot. The provider publishes the share to an object storage location, and recipients use a profile to register and consume the shared data. Recipients see changes when the provider publishes a new version. See Provide Versioned Share for more information.

A Live Share lets an Autonomous AI Database recipient access the latest data directly from the provider database. Live Share uses cloud links and is intended for Oracle AI Database consumption; for live shares in the same region, recipients see current data at query time. See Provide Live Share for more information.

Before you begin

Before using Data Share, verify the following:

The user can access Database Actions and has the required Data Studio role, such as DWROLE, unless using the ADMIN user.
Sharing is enabled from the Data Share tool. The access workflow opens Data Studio, launches Data Share, selects Provide Share, and enables sharing for the selected user schema. See Access and Enable the Data Share Tool for details.
For Versioned Share providers, the provider must have read and write access to an object storage bucket used to store or cache shares.
For Live Share providers, configure Share provider Identity in Data Studio Settings so recipients can identify the provider.
Configure SMTP in Data Studio Settings if you want Data Share to send recipient activation links or share notifications by email. See Data Studio Settings for more details.

Open Data Share

To open Data Share:

Open Database Actions for your Autonomous AI Database.
Select the Data Studio tab.
Select Data Share.
Select Provide Share to create and manage shares, or Consume Share to subscribe to shares made available by a provider.
Enable sharing if prompted, then follow the provider or consumer workflow in Data Studio Documentation.

What you can do in Data Share

Provide Share: View shares and recipients, create new shares, create recipients, configure provider identification, publish shares, manage versions, manage recipients and profiles, unpublish shares, and delete share entities. See Provide Share for detailed provider workflow for creating versioned shares, live shares, recipients, share entities, and share recipient details.
- Provide Versioned Share: Publish data as distinct versions in object storage. Recipients see changes only after the provider publishes a new version.
- Provide Live Share: Share data through a direct connection so supported Autonomous AI Database recipients can query current data.
- Create Share Recipient: Register recipients, provide email and sharing details, set token lifetime, and grant one or more shares to the recipient.
Consume Share: Subscribe to a share provider, register available shares, create external tables or views, and query the shared objects from SQL. See Consume Share for detailed consumer workflow for subscribing to versioned and live share providers and creating queryable objects from shared data.
- Consume Versioned Share: Upload or paste a Delta Sharing JSON profile, subscribe to a provider, select shares, and link shared objects for use in Autonomous AI Database.
- Consume Live Share: Subscribe to an available Live Share provider and create views of tables included in the live share.
Manage shares with DBMS_SHARE: Use PL/SQL to create and publish shares, add or remove tables and views, register recipients, grant or revoke access, manage lifecycle, discover shares, and monitor or troubleshoot sharing workflows. See Manage Shares Using DBMS_SHARE to automate PL/SQL workflow for provider and consumer sharing operations.

Data Share Limitations with Autonomous AI Database

Only Oracle Database 19c supports both Versioned Share and Live Share. Data Share also supports a defined set of column types, and Live Share providers can create shares with a maximum of four objects. If multiple source tables are joined together, Oracle recommends creating a view that performs the joins and sharing the view instead. See Data Share Limitations on Autonomous AI Database to review the list of supported column types.
A live share data provider can create shares with a maximum of four objects.
If the live share data provider is sharing multiple tables which would be joined together, it is recommended that the producer create a view that performs the joins and then only shares the view.
For Live Share performance, increasing ECPUs alone may not improve complex query performance. The Troubleshooting Guide explains how an administrator can configure degree of parallelism through resource management settings.
When Autonomous AI Database consumes Delta Sharing data, it does not support Delta tables that have Deletion Vectors enabled. If a shared Delta table uses Deletion Vectors, ask the provider to remove Deletion Vectors or provide a compatible share. See Shared Table Query Attempt Failure for guidance.