RE: Export - Import from Oracle v8 to v731

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Thu, 04 Oct 2001 05:46:19 -0700
Message-ID: <F001.003A1B55.20011004054022@fatcity.com>

There is a compatible parameter for the init<sid>.ora file.

The parameter is probably already there, just set for your current version as it is generally included by default.

"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."

Christopher R. Spence
<span

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

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

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

Fuelspot
<span

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

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

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Nirmal Kumar Muthu Kumaran
[mailto:NIRMALK_at_qtel.com.qa]
Sent: Thursday, October 04, 2001
8:40 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Export - Import from
Oracle v8 to v731

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Hi christopher,

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>How i can make my orace8 server compatible with v731... is i can set any init.ora parameter....

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>or something different....

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Nirma,

-----Original Message-----
From: tday6_at_csc.com [SMTP:tday6_at_csc.com]

Sent: Wednesday, October 03, 2001 8:30 PM

To: Multiple recipients
of list ORACLE-L
Subject:
RE:
Export - Import from Oracle v8 to v731

Don't know if this would work, but here's a thought.

Go to the 731 box, set up a connect string to the v8 box. Using the 731
exp,
export the v8 database (after you set its compatible option to 7 and

bounce
it). See if it will import using the 731 imp.

I don't have any environment to test this in but I think I remember that
using
the 731 exp is the trick.

<span style='font-size:

10.0pt;font-family:Arial'>                                                                                          

                   
Christopher

Spence
To: Multiple recipients of list

ORACLE-L

<cspence
<ORACLE-L_at_fatcity.com>

@FuelSpot.com

Subject: RE: Export - Import from Oracle v8

Sent by: root to

12:25

respond

You generally cannot export from a higher leveldatabase to a lower.
Although
you can probably change the compatible option to 7.3.4 and do it that
way (from what I hear, never tried it).

"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."

Christopher R. Spence Oracle
DBA
Phone:
(978) 322-5744
Fax:
(707) 885-2275

Fuelspot
73
Princeton Street
North,
Chelmsford 01863

<span

style='font-size:12.0pt'>

-----Original Message----- Sent:
Wednesday, October 03, 2001 11:25 AM
To:
Multiple recipients of list ORACLE-L

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.

<span

style='font-size:12.0pt'>

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

-- 
Author:

 
INET: tday6_at_csc.com 



<span style='font-size:

10.0pt;font-family:Arial'>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 Thu Oct 04 2001 - 07:46:19 CDT