RE: Export - Import from Oracle v8 to v731

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>You generally cannot export from a <span class=GramE>higher level database to a lower.<span style='mso-spacerun:yes'>  Although you can probably change the compatible option to 7.3.4 and do it that way (from what I hear, never tried it).

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:12.0pt;

color:navy;mso-no-proof:yes'>"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

<span style='font-size:18.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Christopher R. Spence<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA<span style='color:navy;
mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744<span
style='color:navy;mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax:    (707) 885-2275<span
style='color:navy;mso-no-proof:yes'>

<span style='font-size:10.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Fuelspot<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street<span style='color:navy; mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863<span
style='color:navy;mso-no-proof:yes'>
 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Nirmal Kumar Muthu Kumaran
[mailto:NIRMALK_at_qtel.com.qa]
Sent<span
style='font-weight:bold'>: Wednesday, October 03, 2001 11:25 AM To: Multiple recipients of list
ORACLE-L
Subject: Export - Import from
Oracle v8 to v731

<span

style='font-size:12.0pt'> 

<span style='font-size:

10.0pt;font-family:Arial'>Hi gurus,

<span style='font-size:

10.0pt;font-family:Arial'>i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax).

<span style='font-size:

10.0pt;font-family:Arial'>I successfully completed the export process:

<span style='font-size:

10.0pt;font-family:Arial'>c:\>exp80 parfile=c:\exp_par.dat

<span style='font-size:

10.0pt;font-family:Arial'>exp_par.dat

userid=msalah/msalah_at_qtel

file=c:\test.dmp

tables=(ctv_tv_dockets)

grants=y

indexex=y

<span style='font-size:

10.0pt;font-family:Arial'>then am importing this dump file into oracle v731 which is running on vms-vax.

<span style='font-size:

10.0pt;font-family:Arial'>imp_par.dat

userid="ops$cssdba/cssdba#act_at_csscli"

file=c:\test.dmp

tables=(*)

fromuser=msalah

touser=ops$cssdba

<span style='font-size:

10.0pt;font-family:Arial'>c:\>imp71 parfile=c:\imp_par.dat

<span style='font-size:

10.0pt;font-family:Arial'>here it's giving problem:

<span style='font-size:

10.0pt;font-family:Arial'>IMP-00003: ORACLE error 12151 encountered

ORA-12154:
TNS: could not resolve service name
IMP-00000:
Import terminated unsucessfully

<span style='font-size:

10.0pt;font-family:Arial'>Note that in interactive mode also i tried to import, but it's also not working.

<span style='font-size:

10.0pt;font-family:Arial'>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.

<span style='font-size:

10.0pt;font-family:Arial'>anyone have any idea...

<span style='font-size:

10.0pt;font-family:Arial'>rgds,
Nirmal. Received on Wed Oct 03 2001 - 10:44:15 CDT