EXPDP-UED-00018数据泵导出数据提示版本不一致
OS：Oracle Enterprise Linux 5.7DB version：11G R2 11.2.0.1 单实例
$ expdp jssi/**** schemas=jssi directory=data_pump_dir dumpfile=jssi20140416.dmp CONTENT=METADATA_ONLY
Export: Release 11.2.0.1.0 - Production on Wed Apr 16 22:23:42 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0
$ oerr ude 18
00018, 00000, "Data Pump client is incompatible with database version %s"
// *Cause: The Export utility is at a higher version than the database
// version and is thereby incompatible.
// *Action: Use the same version of Export utility as the database.
$ expdp jssi/jssi schemas=jssi directory=data_pump_dir dumpfile=jssi20140416.dmp CONTENT=METADATA_ONLY version ='11.2.0.1.0'
Export: Release 11.2.0.1.0 - Production on Wed Apr 16 22:24:22 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0
在本机上面导出数据提示客户端版本不一致 。数据库 和导出数据库的操作在同一台及其上面 版本一致，请问从哪里下手解决 select owner, object_name, object_type, status from dba_objects where status != 'VALID';
@$ORACLE_HOME/rdbms/admin/utlrp
ODM FINDING:
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1 (Doc ID 1274439.1)
APPLIES TO:
Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2
Information in this document applies to any platform.
SYMPTOMS
You recently installed a patch into your database. Since then the DataPump export utility (expdp) fails with errors message:
Export: Release 11.2.0.1.0 - Production on Thu Dec 16 10:40:39 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0
CAUSE
Invalid packages DBMS_METADATA_INT or/and DBMS_METADATA_UTIL can produce such a behavior.
SOLUTION
1. Verify, if packages DBMS_METADATA_UTIL/DBMS_METADATA_INT are invalid:
SQL> connect / as sysdba
SQL> select owner, object_name, object_type, status from dba_objects where status != 'VALID';
2. Re-compile the invalid objects with:
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/utlrp
and retry with DataPump export.
Note: If the packages don't become valid, then check the root cause in view DBA_ERRORS.
UDE-18 (Data Pump client is incompatible with database version xx.yy).
%expdp system/manager@m10102wa DIRECTORY=my_dir \
DUMPFILE=expdp_s.dmp LOGFILE=expdp_s.log SCHEMAS=scott
Export: Release 10.2.0.3.0 - Production on Tuesday, 26 February, 2008 14:46:22
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
UDE-00018: Export utility version can not be more recent than the Data Pump server.
or:
%expdp system/manager@m10203wa DIRECTORY=my_dir \
DUMPFILE=expdp_s.dmp LOGFILE=expdp_s.log SCHEMAS=scott
Export: Release 11.1.0.6.0 - Production on Tuesday, 26 February, 2008 14:49:43
Copyright (c) 2003, 2007, Oracle. All rights reserved.
UDE-00018: Data Pump client is incompatible with database version 10.2.0.3.0
Cause: An attempt was made to connect with a higher version Export Data Pump client (e.g. 11.1.0.6.0) to a lower version database (e.g. 10.2.0.3.0), where the Export Data Pump client used Oracle Net to connect to the lower version database. This is not supported.
Action: Use the Export Data Pump client that matches the database version of the source database (i.e.: 10.2.0.3.0 in this case, or any other lower release Export Data Pump client). 如2楼的 回复：
@$ORACLE_HOME/rdbms/admin/utlrp
页:
[1]