Re:Export - Import from Oracle v8 to v731

From: <dgoulet_at_vicr.com>
Date: Wed, 03 Oct 2001 09:00:01 -0700
Message-ID: <F001.003A0906.20011003082029@fatcity.com>

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 <NIRMALK_at_qtel.com.qa>
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_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.

<!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>

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 
 <FONT SIZE=2

FACE="Arial">-------------------------------------------------------------</FONT

>
 userid="ops$cssdba/cssdba#act_at_csscli"
 <FONT SIZE=2

FACE="Arial">------------------------------------------------------------</FONT>

 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.


</BODY>
</HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Oct 03 2001 - 11:00:01 CDT