Home » RDBMS Server » Server Utilities » Issue in importing the fully exported dump file. (Windows server 2016.)
Issue in importing the fully exported dump file. [message #673377] Sun, 18 November 2018 09:43 Go to previous message
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.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to Import(IMPDP) an Schema having trailing space from an FULL export dump in Windows 2008R2 ( 64
Next Topic: Query on importing dump file.
Goto Forum:
  


Current Time: Mon Jan 27 16:39:07 CST 2020