Issue in importing the fully exported dump file. [message #673377] |
Sun, 18 November 2018 09:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/44828078b51a595c9c65574a30ee65c6?s=64&d=mm&r=g) |
rajeshsvnr
Messages: 9 Registered: June 2017
|
Junior Member |
|
|
Hi All,
I have an issue in importing the dump file.
I have one full exported dump file in one server1 which consists of all users.
Server1 has below tablespaces:-
Tablespace Datafile
-------------------------
MARIAN D:\ORADATA\SDBFT\DBF\MARIAN01.DBF
M_INDEX D:\ORADATA\SDBFT\DBF\M_INDEX03.DBF
I need to import that dump file into server2.I did not created any users and tablespaces in server2.
I imported the dumpfile using the below command.
>impdp DIRECTORY=DATA_PUMP_DIR LOGFILE=fibimport.log DUMPFILE=FIB_CURRENT01.DMP full=y
When i tried to import the dump file, am getting the errors like
cannot create datafile D:\ORADATA\SDBFT\DBF\MARIAN01.DBF
and user invalid.
Can anyone suggest me of how to import the dumpfile.
|
|
|
|
|
|