OraFAQ Forum: Server Utilities » Export from 8i and Import to 10g

Home » RDBMS Server » Server Utilities » Export from 8i and Import to 10g (oracle 10g & 8i os:-windows xp sp3)

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

Export from 8i and Import to 10g [message #628990]

Mon, 01 December 2014 23:40

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

Is it possible to export dump file from Oracle 8i and Import of that file in 10g.
and if yes then how.

Let me explain what i tried:-

1. I took export from 8i and saved the dump file in C Drive.
2. connected to / as sysdba using oracle 10g.
3. now following are the commands i ran:-
i. >create user USERNAME identified by PASSWORD (username/password is the same which i used to export dump file using 8i)
ii. >conn user/password
iii >show user (username shown which i created)
iv. >host
v. in cmd propmt i wrote:- imp username/password@sid file=C:\filename.dmp full=y rows=y
grants=y
4. Now i am getting following error(i have hided username and password sorry for that):-

/forum/fa/12344/0/

Attachment: imp00058.JPG
(Size: 36.51KB, Downloaded 859 times)

[Updated on: Mon, 01 December 2014 23:41]

Report message to a moderator

Re: Export from 8i and Import to 10g [message #628991 is a reply to message #628990]

Mon, 01 December 2014 23:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

Report message to a moderator

Re: Export from 8i and Import to 10g [message #629009 is a reply to message #628991]

Tue, 02 December 2014 03:26

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

removed sid name from command , now the command is working fine , i m able to import now.
thanks

Report message to a moderator

Re: Export from 8i and Import to 10g [message #629011 is a reply to message #629009]

Tue, 02 December 2014 03:49

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

Senior Member

Yes. You're now bypassing the listener. If you want to use the listener, check out the following file: E:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora and the "netca" command.

Report message to a moderator

Previous Topic:	Wrap Utility doesn't work
Next Topic:	Export Problems Oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 16:50:14 CDT 2023