I am using impdp
to import a backup but I use the default directory dumpfile Want to change
$ impdp system / password @ $ ORACLE_SID schema = USER_SCHEMA dump file = mydumpfile.dmp logfile = impdpmydumpfile.log Import: Release 11.2.0.3.0 - Mon output on 16 Mar 09:32:05 2015 Copyright (c) 1982, 2011, Oracle and / or its affiliates all rights reserved. Oracle Database 11G Release 11.2.0.3.0 - 64 bit Production ORA-39001: Invalid logic value ORA-39000: bad dump file specification ORA-31640: Unable to open dump file "/ u01 / app / oracle / admin / mydatabase / Dpdump / mydumpfile.dmp "ORA-27037: Unable to obtain file status Linux-x86_64 error: 2: No such file or directory Additional information: 3
with:
impdp system / password @ $ ORACLE_SID schema = USER_SCHEMA directory = MY_DIR \ dumpfile = m Ydumpfile.dmp logfile = Impdpmydumpfile.log
This is DATA_PUMP_DIR
, which is possibly / u01 / app / oracle / admin / mydatabase / dpdump
Is set to your system.
To use a different directory, you must (or your DBA) in the database, which indicates the Oracle-visible operating system directory in which you put the file, and grant the user privileges. Do import
No comments:
Post a Comment