Home > database >  Oracle database impdp import
Oracle database impdp import

Time:10-08

PS D: \ app \ FJC \ admin \ wouldn \ dpdump> Impdp MMSMGR/MMSMGR @ former remap_schema=MMSMGR: MMSMGR directory=DATA_PUMP_DIR dumpfile=database. The DMP TABLE_EXISTS_ACTION=REPLACE full=y

Import: Release 11.2.0.1.0 - Production on Wednesday July 8 19:04:59 2020

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

To connect to: Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options
ORA - 39001: invalid parameter value
ORA - 39000: dump file specification error
ORA - 39143: dump file "D: \ app \ FJC/admin/former/dpdump/database. The DMP" may be the original export dump file


Using ipm:
PS D: \ app \ FJC \ admin \ wouldn \ dpdump> Imp MMSMGR/MMSMGR @ former directory=DATA_PUMP_DIR file=D: \ app \ FJC \ admin \ wouldn \ dpdump \ database DMP TABLE_EXISTS_ACTION=REPLACE full=y
LRM - 00101: unknown parameter name 'the directory'

IMP - 00022: processing parameters failed, please type 'IMP HELP=Y' HELP information
IMP - 00000: an unsuccessful termination of import

Bosses to solve!!!!!!!!!!!!!!!

CodePudding user response:

The directory you have any question, you check your directory DATA_PUMP_DIR value orientation which path?
Select * from dba_directories;

CodePudding user response:

Two Suggestions:
1, it is better to find out the source of this file is exp or expdp.
2, if the exp is derived, the building Lord first check the syntax rules of imp

Example:

imp system/oracle file=c: \ XXX. DMP fromuser=source_user_name touser=target_user_name log=c: \ XXX log
  • Related