| |
Shortly before the Data Pump tool impdp data import encountered an error, suggesting invalid dunp files by querying the document because they do not know that this is due to the compatible version from high to low version of the cause, the following share solutions.
Import error
C: \ Documents and Settings \ hoegh> impdp hoeghto / ilovehoegh directory = data_pump_directory
dumpfile = 20150826dynamic.dmp remap_schema = hoeghfrom: hoeghto remap_tablespace = hoeghfrom: hoeghto
Import: Release 10.1.0.2.0 - Production on Tue, 01 Sep 2015 9:31
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "d: \ data_pump_directory \ 20150826dynamic.dmp"
C: \ Documents and Settings \ hoegh>
The source database version
SQL> select * from v $ version;
BANNER
-------------------------------------------------- --------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL / SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL>
End target database version
SQL>
SQL> select * from v $ version;
BANNER
-------------------------------------------------- --------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL / SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
SQL>
Add version parameter
The source database version 10.2.0.4.0, 10.1.0.2.0 version of the target-side database, the source database version is higher than the target-side database version; the solution is very simple, with the target end version when exporting data from the source database that is can, see what sql statement:
expdp hoeghfrom / ilovehoegh directory = data_pump_directory dumpfile = 20150826dynamic.dmp tables = (HOEGH) version = 10.1.0.2.0
Next, we execute impdp statement again ok. |
|
|
|