import_error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

import_error

Arsalan

Hello Arslan,

while i import dumpfile which i took from other department mean i don;t know about his database

version and OS so i started to import dumpfile it give errorr like

please guide me


impdp system/*******@dwh DUMPFILE=asyplusdps_all.dmp LOGFILE=asyplus.log remap_schema=OPS$ASY:SIGTASAD remap_tablespace=ASYCUDA_DATA_tra
:IRD_DATA_LARGE table_exists_action=replace

Import: Release 11.2.0.1.0 - Production on Tue Sep 18 13:49:13 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "D:\SIGTASDWH\SIGTASDUMPS\asyplusdps_all.dmp"
Reply | Threaded
Open this post in threaded view
|

Re: import_error

ErmanArslansOracleBlog
Administrator
Probably, it is because of the version.

Fact:
DataPump import cannot read dump file sets created by a database version that is newer than the current database version, unless those dump file sets were created with the version parameter set to the version of the target database.

Read and follow: DataPump Import (IMPDP) Fails With Error ORA-31619 (Doc ID 549750.1)