IMPDP db link import failing
hello all,
I am importing full db but some of the db links are failing to create but some are not
ORA-31685: Object type DB_LINK:"USER"."LINKS" failed due to insufficient privileges. Failing sql is:
CREATE DATABASE LINK "LINKS" CONNECT TO "USER" IDENTIFIED BY VALUES ':1' USING 'TARGET'
what could be causing this?
I just discovered that I have DBA and DATAPUMP_IMP_FULL_DATABASE in the export instance that works but only DATAPUMP_IMP_FULL_DATABASE in the one tht does not.
in the target both instances have the same privs DBA
Thanks
Dave