Thanks for the question, afsar.
Asked: February 14, 2016 - 4:33 am UTC
Last updated: February 14, 2016 - 7:02 am UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
Hi,
I'm tring to import Schema,Unfortunately i'm getting following error.I'm using Windows server 2012.I'm struggling since last week.Plz help.
C:\users\Administrator>impdp scott/tiger@orcl11204 directory=imp dumpfile=tst02.dmp logfile=tst02.log remap_schema=scott:hr1
Note: I'm getting following error
=============================================================================================================
;;;
Import: Release 11.2.0.4.0 - Production on Sun Feb 14 09:38:31 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "d:\ora11g204\imp\tst02.dmp" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
and Connor said...
I'm assuming the Oracle directory IMP you created in database 'orcl11204' points to "d:\ora11g204\imp\" based on the output.
Things to check/note:
1) That file definitely is there ? Don't forget that the import is looking for the file d:\ora11g204\imp\tst02.dmp on the *database server* where 'orcl11204' resides, *not* where you are running the impdp from (just in case you are running it on another machine).
2) The file will be opened by the software owner that oracle is installed as, so the file permissions must allow the oracle database process to see it.
Is this answer out of date? If it is, please let us know via a Comment