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: 63911
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: How to covert the scientific format value into number or text in oracle
Next Topic: Want to use Oracle sequence at the time of loadiing data
Goto Forum:

Current Time: Sat Oct 22 03:57:56 CDT 2016

Total time taken to generate the page: 0.11164 seconds