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.
