OraFAQ Forum: Server Utilities » Issue in importing the fully exported dump file.

Home » RDBMS Server » Server Utilities » Issue in importing the fully exported dump file. (Windows server 2016.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue in importing the fully exported dump file. [message #673377]

Sun, 18 November 2018 09:43

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.

Report message to a moderator

[Message index]

		Issue in importing the fully exported dump file. By: rajeshsvnr on Sun, 18 November 2018 09:43
		Re: Issue in importing the fully exported dump file. By: Michel Cadot on Sun, 18 November 2018 10:17
		Re: Issue in importing the fully exported dump file. By: rajeshsvnr on Tue, 20 November 2018 01:46
		Re: Issue in importing the fully exported dump file. By: gazzag on Tue, 20 November 2018 03:02

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:38:36 CDT 2024