Home » RDBMS Server » Server Utilities » importing data into 10g from 9i (10g)
importing data into 10g from 9i [message #342358] Fri, 22 August 2008 02:11 Go to next message
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member

I am trying to import dump file into 10g using "IMP" command at command prompt. I have installed Oracle 10g on different Server. The exported dump file is from 9i.

i am importing dump file as


username: rss09
password: rss

i have encountered following error after entering username and password

IMP-0058 : oracle error 12560 encountered
ORA-12560: TNS Protocol adaptor error.
IMP-00000: import terminated unsuccessfully.

What could be the reason, please help me.


Re: importing data into 10g from 9i [message #342359 is a reply to message #342358] Fri, 22 August 2008 02:16 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12560: TNS:protocol adapter error
 *Cause: A generic protocol adapter error occurred.
 *Action: Check addresses used for proper protocol specification. Before
 reporting this error, look at the error stack and check for lower level
 transport errors. For further details, turn on tracing and reexecute the
 operation. Turn off tracing when the operation is complete

http://www.orafaq.com/forum/?SQ=2227fc4c3af0d26dfa2852dbe058b64b&t=search&srch=protocol+adapter+error&btn_submit=Search&a mp;field=all&forum_limiter=&search_logic=AND&sort_order=DESC&author=


Previous Topic: insert crores of records
Next Topic: Want to use Oracle sequence at the time of loadiing data
Goto Forum:

Current Time: Wed Aug 23 09:02:59 CDT 2017

Total time taken to generate the page: 0.17051 seconds