[18:39:19 oracle@ogg01 ~]$ expdp \"/ as sysdba\" directory=OGG_TEST dumpfile=ogg_20121212%u.dmp
logfile=ogg_20121212_exp.log flashback_scn=************* tables=scott.t01
Export: Release 11.2.0.3.0 - Production on Fri Dec 12 18:39:20 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39021: Database compatibility version 11.2.0.3.6 is not supported.
[18:39:19 oracle@ogg01 ~]$
==> 出现此问题是因为EXPDP读取到的DB小版本11.2.0.3.6的兼容性存在问题，添加VERSION参数就可以了。具体如下：
expdp \"/ as sysdba\" directory=OGG_TEST dumpfile=ogg_20121212%u.dmp
logfile=ogg_20121212_exp.log flashback_scn=************* tables=scott.t01 version=11.2.0.3
logfile=ogg_20121212_exp.log flashback_scn=************* tables=scott.t01
Export: Release 11.2.0.3.0 - Production on Fri Dec 12 18:39:20 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39021: Database compatibility version 11.2.0.3.6 is not supported.
[18:39:19 oracle@ogg01 ~]$
==> 出现此问题是因为EXPDP读取到的DB小版本11.2.0.3.6的兼容性存在问题，添加VERSION参数就可以了。具体如下：
expdp \"/ as sysdba\" directory=OGG_TEST dumpfile=ogg_20121212%u.dmp
logfile=ogg_20121212_exp.log flashback_scn=************* tables=scott.t01 version=11.2.0.3
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27634305/viewspace-1366199/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
常用脚本整理
请登录后发表评论
登录
全部评论
