ORA-31685: Object type DB_LINK:"NCAOODS"."LINK_SNAPSHOTM" failed due to insufficient privileges. Fai

最新推荐文章于 2024-07-30 08:30:00 发布

司马松儆

最新推荐文章于 2024-07-30 08:30:00 发布

阅读量5.4k

点赞数

分类专栏： Oracle Database管理

本文链接：https://blog.csdn.net/Smasegain/article/details/46653011

版权

在尝试导入数据到 Oracle 数据库时遇到 ORA-31685 错误，问题根源在于创建数据库链接（DB_LINK）时权限不足。通过分析，发现用户 QS 和 NCAOODS 只有创建公共数据库链接的权限，而缺少创建私有数据库链接的权限。解决方案是授予用户相应的 CREATE DATABASE LINK 权限。

摘要由CSDN通过智能技术生成

 
 一.问题描述

2014/11/11导入数据到CPDWH01时出现创建db link失败的报错，使用system或sys用户导入数据的时候都出现以下报错：

Import: Release 11.2.0.4.0 - Production on Tue Nov 11 09:28:04 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" directory=DATA_PUMP_DIR dumpfile=CPDWH01_COMP_%U.dmp logfile=CPDWH01_COMP_imp.log parallel=12
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
ORA-31685: Object type DB_LINK:"NCAOODS"."LINK_SNAPSHOTM" failed due to insufficient privileges. Failing sql is:
CREATE DATABASE LINK "LINK_SNAPSHOTM" CONNECT TO "NCAOWIIM" IDENTIFIED BY VALUES ':1