Summary:
I've set up a share link to a share provide that I've confirmed can be authenticated to by running:
SELECT *FROM DBMS_SHARE.DISCOVER_AVAILABLE_TABLES(share_provider=>'share_provider_share',share_name=>'ORAADB_SHARE');
Although the credentials are correct (and have an unlimited token life time) I'm unable to actually set-up a share link view to access the data with CREATE_SHARE_LINK_VIEW. There's no documentation for this error and you can't see the underlying source code for this package, so it's not possible to derive what is going wrong.
Confirming I've also set-up the APPEND_HOST_ACE config (which I know works because discover available tables works)
Full error:
ERROR at line 90:ORA-20863: Cannot access Share Link "FIN_DATA_PRODUCTS"."DATABRICKS_SIGNALS".ORA-06512: at "C##ADP$SERVICE.DBMS_LINEAGE_ERROR", line 4756ORA-06512: at "C##ADP$SERVICE.DBMS_SHARE", line 419ORA-06512: at "C##ADP$SERVICE.DBMS_SHARE", line 9408ORA-06512: at "C##ADP$SERVICE.DBMS_SHARE", line 9661ORA-06512: at line 2https://docs.oracle.com/error-help/db/ora-20863/
Version (include the version you are using, if applicable):
19c
Code Snippet (add any code snippets that support your topic, if applicable):
Valid share link that was set-up (confirmed share_provider, share credentials and share are set-up already)
BEGINDBMS_SHARE.CREATE_OR_REPLACE_SHARE_LINK( share_link_name => 'DATABRICKS_SIGNALS', share_provider => 'DATABRICKS_PROVIDER', share_name => 'ORAADB_SHARE');END;/
The below two fail:
DECLAREstmt CLOB;BEGIN DBMS_SHARE.GENERATE_SHARE_LINK_SELECT ( share_link_name => 'DATABRICKS_SIGNALS', share_schema_name => 'MY_SCHEMA', share_table_name => 'I_3_FEATURES_SUPPLEMENTED', stmt=>stmt --share_link_owner IN VARCHAR2 := NULL ); DBMS_OUTPUT.PUT_LINE(stmt); /*IN VARCHAR2*/END;
BEGINdbms_share.create_share_link_view( view_name=>'I_3_FEATURES_SUPPLEMENTED_V', share_link_name=>'DATABRICKS_SIGNALS', share_schema_name=>'MY_SCHEMA', share_table_name=>'I_3_FEATURES_SUPPLEMENTED');END;/