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

Re: Issue in importing the fully exported dump file. [message #673378 is a reply to message #673377]

Sun, 18 November 2018 10:17

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must:
1/ copy and paste the export command AND its log (removing the table details)
2/ Copy and paste the import command AND its log (removing the table details)
3/ Post your Oracle versions of BOTH databases, with four decimals
4/ Before, read How to use [code] tags and make your code easier to read and apply it to your post
5/ BEFORE, feedback in your previous topic

[Updated on: Sun, 18 November 2018 10:20]

Report message to a moderator

Re: Issue in importing the fully exported dump file. [message #673439 is a reply to message #673378]

Tue, 20 November 2018 01:46

rajeshsvnr
Messages: 9
Registered: June 2017

Junior Member

The problem regarding the tablespace(cannot create datafile D:\ORADATA\SDBFT\DBF\MARIAN01.DBF) was solved by creating all the tablespaces in the new server.

Report message to a moderator

Re: Issue in importing the fully exported dump file. [message #673440 is a reply to message #673377]

Tue, 20 November 2018 03:02

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You need to pre-create the tablespaces MARIAN and M_INDEX. Check on server1 for all the users' default tablespaces and create them too.

Report message to a moderator

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: Mon Mar 03 17:25:35 CST 2025