You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!