Summary of Share Consumer Views
This table lists the DBMS_SHARE package views.
| View | Description |
|---|---|
| ALL_AVAILABLE_ORACLE_SHARE_PROVIDERS View | This view lists all available Oracle share providers. |
| ALL_SHARE_CACHE_JOB_INFO View | This view contains information on the most recent Oracle Live share cache population job in the current POD. |
| ALL_SHARE_LINKS View | A view containing
all share links that were created using
CREATE_SHARE_LINK.
|
| ALL_SHARE_LINK_VIEWS View | A view that
contains a list of all the views created to access the shared data
using CREATE_SHARE_LINK_VIEW.
|
| ALL_SHARE_PROVIDERS View | A view that
contains one row for each share provider subscription, created by
CREATE_SHARE_PROVIDER.
|
| DBA_SHARE_LINK_VIEWS View | A view that
contains a list of all the views created to access the shared data
using CREATE_SHARE_LINK_VIEW.
|
| DBA_SHARE_LINKS View | A view containing
all share links that were created using
CREATE_SHARE_LINK.
|
| USER_SHARE_LINKS_VIEW View | A view that
contains a list of all the views created to access the shared data
using CREATE_SHARE_LINK_VIEW.
|
| USER_SHARE_LINKS View | A view containing
all share links that were created using
CREATE_SHARE_LINK.
|
| USER_SHARE_PROVIDERS View | A view that contains one row for each share provider subscription, created by CREATE_SHARE_PROVIDER. |
- ALL_AVAILABLE_ORACLE_SHARE_PROVIDERS View
This view lists all available Oracle share providers. - ALL_SHARE_CACHE_JOB_INFO View
This view contains information on the most recent Oracle Live share cache population job in the database. - ALL_SHARE_LINK_VIEWS View
A view that contains a list of all the views created to access the shared data usingCREATE_SHARE_LINK_VIEW. - ALL_SHARE_LINKS View
A view containing all share links that were created usingCREATE_SHARE_LINK. - ALL_SHARE_PROVIDERS View
A view that contains one row for each share provider subscription, created byCREATE_SHARE_PROVIDER. - DBA_SHARE_LINK_VIEWS View
A view that contains a list of all the views created to access the shared data usingCREATE_SHARE_LINK_VIEW. Its columns are the same as those in theALL_SHARE_LINK_VIEWSview. - DBA_SHARE_LINKS View
A view containing all share links that were created usingCREATE_SHARE_LINK. Its columns are the same as those in theALL_SHARE_LINKSview. - USER_SHARE_LINKS_VIEW View
A view that contains a list of all the views created to access the shared data usingCREATE_SHARE_LINK_VIEW. Its columns are the same as those in theALL_SHARE_LINK_VIEWSview. - USER_SHARE_LINKS View
A view containing all share links that were created usingCREATE_SHARE_LINK. Its columns are the same as those in theALL_SHARE_LINKSview. - USER_SHARE_PROVIDERS View
A view that contains one row for each share provider subscription, created byCREATE_SHARE_PROVIDER. Its columns are the same as those in theALL_SHARE_PROVIDERSview.
Parent topic: DBMS_SHARE Package
ALL_AVAILABLE_ORACLE_SHARE_PROVIDERS View
This view lists all available Oracle share providers.
| Column | Datatype | Description |
|---|---|---|
ORACLE_PROVIDER_ID |
VARCHAR2 |
A UUID for the Oracle provider. |
PROVIDER_NAME |
VARCHAR2 |
A name, as specified by the provider. Note that this is not unique. |
DESCRIPTION |
VARCHAR2 |
A description, as specified by the provider. |
CONTACT |
VARCHAR2 |
A contact address, such as an email, for the provider. |
METADATA |
CLOB |
Additional JSON metadata, as specified by the provider. |
SHARES |
CLOB |
A JSON representation of the list of shares available from this provider. |
CREATED |
TIMESTAMP(6) |
The time when the share provider was first registered. |
UPDATED |
TIMESTAMP(6) |
The time when the share provider was last updated. |
Parent topic: Summary of Share Consumer Views
ALL_SHARE_CACHE_JOB_INFO View
This view contains information on the most recent Oracle Live share cache population job in the database.
| Names | Datatype | Description |
|---|---|---|
LAST_RUN_DATE |
TIMESTAMP(6) WITH TIME ZONE |
The start time of the most recent cache job execution. |
NEXT_RUN_DATE |
TIMESTAMP(6) WITH TIME ZONE |
The scheduled start time of the next cache job execution. |
RUN_STATUS |
NUMBER |
The status of the most recent run (0 = success). A non zero value represents the numeric code of the exception, as reported by the SQL CODE function. |
MESSAGE_TEXT |
VARCHAR2(4000) |
A text indicating
a warning or error condition encountered by the most recent run.
NULL in most cases; indicates a warning if
RUN_STATUS is 0, an error otherwise.
|
REPEAT_INTERVAL |
VARCHAR2(4000) |
The
DBMS_SCHEDULER repeat interval for the cache
job.
|
Parent topic: Summary of Share Consumer Views
ALL_SHARE_LINK_VIEWS View
A view that contains a list of all the views created to access the shared
data using CREATE_SHARE_LINK_VIEW.
See CREATE_SHARE_LINK_VIEW Procedure for further information.
| Names | Datatype | Description |
|---|---|---|
LINK_OWNER |
VARCHAR2 |
The owner of the associated share link. |
LINK_NAME |
VARCHAR2 |
The name of the associated share link. |
SHARE_SCHEMA_NAME |
VARCHAR2 |
The name of the share schema, as supplied by the share provider. |
SHARE_TABLE_NAME |
VARCHAR2 |
The name of the share table, as supplied by the share provider. |
VIEW_OWNER |
VARCHAR2 |
The owner of the local view. |
VIEW_NAME |
VARCHAR2 |
The name of the local view. |
Parent topic: Summary of Share Consumer Views
ALL_SHARE_LINKS View
A view containing all share links that were created using
CREATE_SHARE_LINK.
See CREATE_SHARE_LINK Procedure for further information.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2 |
The owner of the share link. |
LINK_NAME |
VARCHAR2 |
The name of the share link. |
LINK_ID |
NUMBER |
A numeric ID for the share link. |
SHARE_TYPE |
VARCHAR2 |
The type of share provider: DELTA or ORACLE. |
SHARE_NAME |
VARCHAR2 |
The name of the share. |
SHARE_PROVIDER_NAME |
VARCHAR2 |
The name of the share provider. |
SHARE_PROVIDER_OWNER |
VARCHAR2 |
The owner of the share provider. |
SHARE_PROVIDER_ID |
NUMBER |
A numeric ID for the provider. |
METADATA_PATH |
VARCHAR2 |
The lineage path of the share link. |
SHARE_CREDENTIAL_NAME |
VARCHAR2 |
(DELTA) The name of the credential used to access the endpoints. |
METADATA |
BLOB |
Additional metadata, supplied by the user. |
ORACLE_SHARE_PROVIDER_ID |
VARCHAR2 |
(ORACLE) A globally unique GUID for the Oracle share provider. |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
The date this share link was created. |
UPDATED |
TIMESTAMP(6) WITH TIME ZONE |
The date this share link was last modified. |
Parent topic: Summary of Share Consumer Views
ALL_SHARE_PROVIDERS View
A view that contains one row for each share provider subscription, created
by CREATE_SHARE_PROVIDER.
See CREATE_SHARE_PROVIDER Procedure for further information.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2 |
The user who subscribed to the share provider. |
PROVIDER_NAME |
VARCHAR2 |
The local name given to the share provider. |
PROVIDER_ID |
VARCHAR2 |
A numeric ID for the provider. |
ENDPOINT |
VARCHAR2 |
(DELTA) The delta endpoint for the provider. |
SHARE_TYPE |
VARCHAR2 |
The type of share provider: DELTA or ORACLE. |
METADATA_PATH |
VARCHAR2 |
The lineage path for the share provider. |
SHARE_CREDENTIAL_NAME |
VARCHAR2 |
(DELTA) The name of the credential used to access the delta endpoints. |
METADATA |
BLOB |
Additional metadata, provided by the user. |
ORACLE_PROVIDER_ID |
VARCHAR2 |
(ORACLE) A globally unique GUID for the Oracle share provider. |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
The date this share provider was created. |
UPDATED |
TIMESTAMP(6) WITH TIME ZONE |
The date this share provider was last modified. |
Parent topic: Summary of Share Consumer Views
DBA_SHARE_LINK_VIEWS View
A view that contains a list of all the views created to access the shared
data using CREATE_SHARE_LINK_VIEW. Its columns are the same as those in the
ALL_SHARE_LINK_VIEWS view.
See Also:
Parent topic: Summary of Share Consumer Views
DBA_SHARE_LINKS View
A view containing all share links that were created using
CREATE_SHARE_LINK. Its columns are the same as those in the
ALL_SHARE_LINKS view.
See Also:
Parent topic: Summary of Share Consumer Views
USER_SHARE_LINKS_VIEW View
A view that contains a list of all the views created to access the
shared data using CREATE_SHARE_LINK_VIEW. Its columns are the same as those
in the ALL_SHARE_LINK_VIEWS view.
See Also:
Parent topic: Summary of Share Consumer Views
USER_SHARE_LINKS View
A view containing all share links that were created using
CREATE_SHARE_LINK. Its columns are the same as those in the
ALL_SHARE_LINKS view.
See Also:
Parent topic: Summary of Share Consumer Views
USER_SHARE_PROVIDERS View
A view that contains one row for each share provider subscription, created
by CREATE_SHARE_PROVIDER. Its columns are the same as those in the
ALL_SHARE_PROVIDERS view.
See Also:
Parent topic: Summary of Share Consumer Views