Database Link Creation through NON-ADMIN user in Autonomous Database Is Failing with 'PLS-00201: identifier 'DBMS_CLOUD_ADMIN' must be declared'
(Doc ID 2592198.1)
Last updated on SEPTEMBER 30, 2019
Applies to:Autonomous Data Warehouse - Version N/A to N/A
Information in this document applies to any platform.
Database Link Creation through NON-ADMIN user is failing and reporting below error :
Command Executed :
db_link_name => 'STAGING2_PROD',
hostname => 'XXX.XXX.XX.XXX',
port => '1521',
service_name => 'ORCL.608140747.oraclecloud.internal',
ssl_server_cert_dn => 'CN=dbcs',
credential_name => 'DBCS_LINK_XXXX',
directory_name => 'DATA_PUMP_DIR');
Error Reported :
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document