ORA-39002 ORA-39168

news/2024/11/23 13:15:28/

impdp导入报错ORA-39002 ORA-39168

$ impdp \'/ as sysdba\'  parfile=impdp.par
Import: Release 11.2.0.4.0 - Production on Fri Apr 16 10:57:13 2021Copyright (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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation						#无效的操作
ORA-39168: Object path TRIGGER was not found.		#找不到触发器对象路径 
ORA-39168: Object path SYNONYM was not found.		#找不到同义词对象路径
ORA-39168: Object path FUNCTION was not found.		#找不到函数对象路径
ORA-39168: Object path PROCEDURE was not found.		#找不到程序对象路径$#impdp.par导入文件中EXCLUDE部分内容如下:
EXCLUDE=(STATISTICS,PROCEDURE,FUNCTION,SYNONYM,GRANT,TRIGGER,index)

报错:
无效的操作、找不到触发器对象路径等.

原因:
因为在导出时,表中就没有TRIGGER、SYNONYM、FUNCTION、PROCEDURE等,所以在导入时指定EXCLUDE(排除)这些参数就会报错。

解决:
将报错的参数从导入文件impdp.par去掉即可正常导入.


http://www.ppmy.cn/news/142815.html

相关文章

VS-RK3399性能介绍

VS-RK3399采用6核64位处理器,主频1.8Ghz。GPU采用Mali-T860 GPU, OpenGL ES1.1/2.0/3.0/3.1, OpenVG1.1, OpenCL,DX11等规范。 搭载嵌入式Android 7.1版本系统,板载DDR3 2GB内存, 并可支持3G/4G通信模块扩展,HDMIEDPMIPI显示输出(支持1080P) 板载16GB NA…

DFB激光器电流温度与波长的关系

电流增加,波长增加,温度电压增加,温度降低,波长减小 图里面是温度的电压,不是温度,所以随着温度电压(热敏电阻电压)的增大,温度降低,波长减小 DFB激光器-北京…

rtx3090显卡什么级别 rtx3090显卡什么水平 3090属于什么档次的显卡

3090是最强显卡 3090全称:RTX 3090显卡,2020年9月2日正式发布。搭载24GB GDDR6X显存,采用三插槽体积,双轴流线型散热器设计。rtx3090怎么样这些点很重要 http://www.adiannao.cn/dq 2、RTX 3090显卡与上一代RTX 3080显卡对比&…

NVIDIA GeForce GT 730 配置 CUDA

1.下 cuda toolkit 8.0 CUDA Toolkit 8.0 GA1 Download | NVIDIA Developer 2.下 cuDNN 6.0 cuDNN Archive | NVIDIA Developer 3. 把 cuDNN 里的 bin、include、lib 里的东西放到 C:Program FilesNVIDIA GPU Computing ToolkitCUDAv8.0 相应文件夹里 4. 5. conda instal…

R中报错Error in idx[i, ] <- res[[i]][[1]] : number of items to replace is not a multiple of

运行predictions.assay <- TransferData(anchorset anchors, refdata allen_reference$cell_type, prediction.assay TRUE, weight.reduction ca_6[["pca"]], dims 1:30)时 报错Error in idx[i, ] <- res[[i]][[1]] : n…

ORA-39002 ORA-39358 错误处理方法

问题说明 在做数据库还原时出现ORA-39002 和 ORA-39358 错误&#xff0c;具体信息如下&#xff1a; $ impdp rui/oracle directorydmp_dir dumpfiletest_expdp20210514.dmp logfiletest_impdp202105141.log job_namerui202105141_jobImport: Release 12.1.0.2.0 - Productio…

ORA-39325 ORA-39112

impdp导入报错ORA-39325 ORA-39112 $ impdp \/ as sysdba\ parfileimpdp.par Import: Release 11.2.0.4.0 - Production on Fri Apr 16 11:05:43 2021Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Ente…

ORA-39095

报错 ORA-39095: 转储文件空间已耗尽: 无法分配 8192 字节 原因 1、磁盘空间不足&#xff0c;增大磁盘空间或者删除不必要的文件释放空间即可。 2、官方解释 Because each active worker process or I/O server process writes exclusively to one file at a time, an insuf…