Database Utilities (MOSC)

MOSC Banner

IMPDP db link import failing

edited Nov 30, 2020 9:26PM in Database Utilities (MOSC) 8 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center