ORA-39358: Export Dump File Version 12.2.0 Not Compatible With Target Version 11.2.0
来源:互联网 发布:拒绝退款 淘宝介入 编辑:程序博客网 时间:2024/06/05 20:37
开发人员在测试环境导入数据库报出如题般错误:
ORA-39358: Export Dump File Version 12.2.0 Not Compatible With Target Version 11.2.0
这种版本不一致的情况,常见于高版本向低版本导入。一般通过在做expdp导出的时候加上version解决
但是我检查了下源端数据库,和目标端数据库发现,数据库版本都是12.2的,顿时觉得有点晕。
灵光一下,想到compatible参数,结果show下发现,目标端的值竟然是11.2的。。。
然后仔细看了下这个环境的建库情况,推断出,该环境应该是开发人手工建库的,在参数文件中,将compatible设置成了11.2
---------------------------------------------------------------------------------------------------------------------
对于这样的情况,其实dmp文件的属性值还是12.2的,所以在import语句中,加上version-12.2.0,也能解决该问题。但最好还是将参数compatible修改成12.2.0,然后重启数据库。
阅读全文
0 0
- ORA-39358: Export Dump File Version 12.2.0 Not Compatible With Target Version 11.2.0
- ORA-00331: log version 11.2.0.0.0 incompatible with ORACLE version 10.2.0.3.0
- SLF4J: The requested version 1.5.8 by your slf4j binding is not compatible with [1.6]
- The provider is not compatible with the version of Oracle client
- The requested version 1.6 by your slf4j binding is not compatible with [1.5.
- Ubuntu 12.04 : “The system network services are not compatible with this version”
- Ubuntu Error: the system network service is not compatible with this version
- SecureSMS Pro Version 2.2 compatible with iOS 4.x
- Android Studio Error: Error:CreateProcess error=216, This version of %1 is not compatible with the v
- SLF4J: The requested version 1.5.8 by your slf4j binding is not compatible with [1.6] SLF4J: See htt
- ORA-00214: controlfile '/u01/app/oracle/oradata/[sid]/control01.ctl' version inconsistent with file
- symbol avpriv_float_dsp_init, version LIBAVUTIL_51 not defined in file libavutil.so.51 with link tim
- SAP3.0相关问题,Could not load file or assembly 'sapnco, Version=3.0.0.42
- u-boot 2015.01 :has EABI version 0, but target u-boot has EABI version 4
- 【Debug】has EABI version 5, but target u-boot has EABI version 0
- MSN - Not compatiable with this version
- taglib definition not consistent with specification version
- VMware7.0 is not compatible with CentOS6.2
- 编写量化策略需要注意的几个细节问题
- android 5大布局详解(初)
- catVSdog完整源码【转】
- jedis是什么?jedis概念
- Tracepro中up vector和normal vector的定义1
- ORA-39358: Export Dump File Version 12.2.0 Not Compatible With Target Version 11.2.0
- play1.x 第一弹 :与play的初次邂逅(搭建,目录结构,生命周期)
- LightOJ 1018 Brush (IV)(状态压缩DP)
- 基本算法--递推
- 如何让 Xcode 在读写上提速100倍?
- KMP算法详解
- 20170814周末记账流水(2017-08-14 10:00)
- Maven快速入门
- emWin 2天速成实例教程005_控件聚焦和用户消息的使用方法