Two problems here, one is the password which you can fix by enclosing it in double quotes not the whole connect string, but since it's a 'OPS$' account, can't you run it without the password? As I recall on VMS with an OPS$ account all you needed was 'imp / file='. Anyway, that's the least of your problems. The biggest is making the V7 import utility work with a V8 dmp file. Did you run the cat7??exp.sql script on NT first??
Dick Goulet ____________________Reply Separator____________________ Author: Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> Date: 10/3/01 7:25 AM Hi gurus, i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax). I successfully completed the export process: c:\>exp80 parfile=c:\exp_par.dat exp_par.dat ------------------- userid=msalah/msalah@qtel file=c:\test.dmp tables=(ctv_tv_dockets) grants=y indexex=y then am importing this dump file into oracle v731 which is running on vms-vax. imp_par.dat ----------------- userid="ops$cssdba/cssdba#act@csscli" file=c:\test.dmp tables=(*) fromuser=msalah touser=ops$cssdba c:\>imp71 parfile=c:\imp_par.dat here it's giving problem: IMP-00003: ORACLE error 12151 encountered ORA-12154: TNS: could not resolve service name IMP-00000: Import terminated unsucessfully Note that in interactive mode also i tried to import, but it's also not working. I'm expecting the problem is around ------------------------------------------------------------- userid="ops$cssdba/cssdba#act@csscli" ------------------------------------------------------------ here the password contains # symbol which refers comment usually. Before once i handled it successfully, but i forgot that way. anyone have any idea... rgds, Nirmal. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>Export - Import from Oracle v8 to v731</TITLE> </HEAD> <BODY> <P><FONT SIZE=2 FACE="Arial">Hi gurus,</FONT> </P> <P><FONT SIZE=2 FACE="Arial">i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax).</FONT> </P> <P><FONT SIZE=2 FACE="Arial">I successfully completed the export process:</FONT> </P> <P><FONT SIZE=2 FACE="Arial">c:\>exp80 parfile=c:\exp_par.dat</FONT> </P> <P><FONT SIZE=2 FACE="Arial">exp_par.dat</FONT> <BR><FONT SIZE=2 FACE="Arial">-------------------</FONT> <BR><FONT SIZE=2 FACE="Arial">userid=msalah/msalah@qtel</FONT> <BR><FONT SIZE=2 FACE="Arial">file=c:\test.dmp</FONT> <BR><FONT SIZE=2 FACE="Arial">tables=(ctv_tv_dockets)</FONT> <BR><FONT SIZE=2 FACE="Arial">grants=y</FONT> <BR><FONT SIZE=2 FACE="Arial">indexex=y</FONT> </P> <P><FONT SIZE=2 FACE="Arial">then am importing this dump file into oracle v731 which is running on vms-vax.</FONT> </P> <P><FONT SIZE=2 FACE="Arial">imp_par.dat</FONT> <BR><FONT SIZE=2 FACE="Arial">-----------------</FONT> <BR><FONT SIZE=2 FACE="Arial">userid="ops$cssdba/cssdba#act@csscli"</FONT> <BR><FONT SIZE=2 FACE="Arial">file=c:\test.dmp</FONT> <BR><FONT SIZE=2 FACE="Arial">tables=(*)</FONT> <BR><FONT SIZE=2 FACE="Arial">fromuser=msalah</FONT> <BR><FONT SIZE=2 FACE="Arial">touser=ops$cssdba</FONT> </P> <P><FONT SIZE=2 FACE="Arial">c:\>imp71 parfile=c:\imp_par.dat</FONT> </P> <P><FONT SIZE=2 FACE="Arial">here it's giving problem:</FONT> </P> <P><FONT SIZE=2 FACE="Arial">IMP-00003: ORACLE error 12151 encountered</FONT> <BR><FONT SIZE=2 FACE="Arial">ORA-12154: TNS: could not resolve service name</FONT> <BR><FONT SIZE=2 FACE="Arial">IMP-00000: Import terminated unsucessfully</FONT> </P> <P><FONT SIZE=2 FACE="Arial">Note that in interactive mode also i tried to import, but it's also not working.</FONT> </P> <P><FONT SIZE=2 FACE="Arial">I'm expecting the problem is around </FONT> <BR><FONT SIZE=2 FACE="Arial">-------------------------------------------------------------</FONT > <BR><FONT SIZE=2 FACE="Arial">userid="ops$cssdba/cssdba#act@csscli"</FONT> <BR><FONT SIZE=2 FACE="Arial">------------------------------------------------------------</FONT> <BR><FONT SIZE=2 FACE="Arial">here the password contains # symbol which refers comment usually. </FONT> <BR><FONT SIZE=2 FACE="Arial">Before once i handled it successfully, but i forgot that way.</FONT> </P> <P><FONT SIZE=2 FACE="Arial">anyone have any idea...</FONT> </P> <P><FONT SIZE=2 FACE="Arial">rgds,</FONT> <BR><FONT SIZE=2 FACE="Arial">Nirmal.</FONT> </P> </BODY> </HTML> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
