Oracle Cloud Infrastructure Documentation

Data Share Limitations on Autonomous AI Database

This section summarizes the limitations of Data Share (both Versioned and Live Share) included in the Oracle Autonomous AI Database.

Oracle Database Release Restriction

Only Oracle Database 19c supports both Versioned Share and Live Share. You cannot use Versioned Share and Live Share with any other database version.

Supported Column Types

Only the following list of column types are supported:
  • BINARY_DOUBLE
  • BINARY_FLOAT
  • CHAR
  • CLOB
  • DATE
  • FLOAT
  • INTERVAL DAY TO SECOND
  • INTERVAL YEAR TO MONTH
  • NCHAR
  • NCLOB
  • NUMBER
  • NVARCHAR2
  • TIMESTAMP
  • VARCHAR2
Live Share Data Provider
The following are limitations for using the Data Share tool as a Data Share provider:
  1. A live share data provider can create shares with a maximum of four objects.
  2. If the live share data provider is sharing multiple tables which would normally be joined together, it is recommended that the producer create a view that performs the joins and then only shares the view.
  3. When consuming data via the Delta Sharing protocol, the Autonomous AI Database does not support Delta tables that have Deletion Vectors (DV) enabled. If a shared table has Deletion Vectors, recipients using the Autonomous AI Database will not be able to query it. Ask the provider to remove Deletion Vectors from the table (for example, in Databricks Runtime 16.3+ use ALTER TABLE <table_name> DROP FEATURE deletionVectors) or provide a DV-free copy for sharing. See What are deletion vectors? for more details.

Parent topic: The Data Share Tool