OraFAQ Forum: Server Utilities » How To Import The .DMP File into The DataBase in Oracle9i

Home » RDBMS Server » Server Utilities » How To Import The .DMP File into The DataBase in Oracle9i (Oracle9i,Windows2003)

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

How To Import The .DMP File into The DataBase in Oracle9i [message #417415]

Sat, 08 August 2009 01:11

venkatesh.M.P
Messages: 37
Registered: February 2009
Location: india

Member

When i am going to IMPORT the .DMP file its gets terminated in the middle how to do it

Report message to a moderator

Re: How To Import The .DMP File into The DataBase in Oracle9i [message #417420 is a reply to message #417415]

Sat, 08 August 2009 02:08

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

Senior Member
Account Moderator

My car stops in the middle of the trip.
"how to do it"

Regards
Michel

Report message to a moderator

Re: How To Import The .DMP File into The DataBase in Oracle9i [message #417431 is a reply to message #417415]

Sat, 08 August 2009 08:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post something for us to start with.
Post the log/session with exact error message.

Report message to a moderator

Re: How To Import The .DMP File into The DataBase in Oracle9i [message #417510 is a reply to message #417415]

Mon, 10 August 2009 00:06

venkatesh.M.P
Messages: 37
Registered: February 2009
Location: india

Member

I have configured a windows2003 server with oracle9i in that i want to dump the file which i have taken from linux server how to do that. For suppose my dmp file name is dds290609.dmp & dds290609.log how to do this

Report message to a moderator

Re: How To Import The .DMP File into The DataBase in Oracle9i [message #417511 is a reply to message #417415]

Mon, 10 August 2009 00:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how to do this
I am not clear what "this" is.

>When i am going to IMPORT the .DMP file its gets terminated in the middle how to do it

log files or error messages might contain clues.

Report message to a moderator

Re: How To Import The .DMP File into The DataBase in Oracle9i [message #417512 is a reply to message #417415]

Mon, 10 August 2009 00:28

venkatesh.M.P
Messages: 37
Registered: February 2009
Location: india

Member

MP-00009: abnormal end of export file
IMP-00020: long column too large for column buffer size (15)
IMP-00018: partial import of previous table completed: 4422 rows imported
Import terminated successfully with warnings.

Report message to a moderator

Re: How To Import The .DMP File into The DataBase in Oracle9i [message #417513 is a reply to message #417415]

Mon, 10 August 2009 00:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

We do not know what happened before.
We do not know what you are doing.

No solution is available.

Report message to a moderator

Re: How To Import The .DMP File into The DataBase in Oracle9i [message #417607 is a reply to message #417512]

Mon, 10 August 2009 08:01

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Sounds like you may have transferred your file in ASCII mode, but with the way you give us information little by little, like a treasure hunt, no one can help you.

Report message to a moderator

Previous Topic:	import 10g to 9i
Next Topic:	SQL Loader .ctl script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 20:19:37 CST 2024