Printable View
I'm trying to migrate from 10.1-32 to 10.2-64.
IMPDP doesn't want to work. What should I do?
Import: Release 10.2.0.1.0 - 64bit Production on Monday, 02 July, 2007 21:35:01
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 and Data Mining options
UDI-00018: Import utility version can not be more recent than the Data Pump server.
00018, 00000, "Import utility version can not be more recent than the Data Pump server."
// *Cause: The Import utility is at a higher version than the database
// version and is thereby incompatible.
// *Action: Use the same version of Import utility as the database.
No, it's not newer than server. It's newer than dump, created by 10.1
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@db1 ~]$ impdp system/svsys@SV full=Y directory=BACKUP dumpfile=EXPDAT01-29062007.DMP logfile=import.log
Import: Release 10.2.0.1.0 - 64bit Production on Monday, 02 July, 2007 22:44:15
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 and Data Mining options
UDI-00018: Import utility version can not be more recent than the Data Pump server.
why you are using 10.1 impdp?
Use 10.2 executable Expdp/Impdp to export and import 10.1 db.
I am not using. Data pump is 10.2, but dump-file is made bu 10.1
do you mean I should copy 10.2-expdp to 10.1-machine and run export?
Install a separate 10.2 ORA home and use its exe's is a workaround.
Can u please specify the exact command line u use for import