Home » RDBMS Server » Server Utilities » How To Import The .DMP File into The DataBase in Oracle9i (Oracle9i,Windows2003)
How To Import The .DMP File into The DataBase in Oracle9i [message #417415] Sat, 08 August 2009 01:11 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
My car stops in the middle of the trip.
"how to do it"

Regards
Michel
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Post something for us to start with.
Post the log/session with exact error message.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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.
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 Go to previous message
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.
Previous Topic: import 10g to 9i
Next Topic: SQL Loader .ctl script
Goto Forum:
  


Current Time: Fri Mar 29 01:23:17 CDT 2024