Export - Import from Oracle v8 to v731

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Wed, 03 Oct 2001 07:42:09 -0700
Message-ID: <F001.003A06E7.20011003072520@fatcity.com>

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_at_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_at_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_at_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. Received on Wed Oct 03 2001 - 09:42:09 CDT