DBMS_SHARE.CREATE_SHARE_LINK_VIEW failing with ora-20863
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)
0