Oracle Cloud Infrastructure Documentation

Data Share Limitations on Autonomous Database

This section summarizes the limitations of Data Share (both Versioned and Live Share) included in the Oracle Autonomous 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.

Parent topic: The Data Share Tool