RE: Export - Import from Oracle v8 to v731

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Thu, 04 Oct 2001 04:48:57 -0700
Message-ID: <F001.003A1A95.20011004044019@fatcity.com>

Hi christopher,

How i can make my orace8 server compatible with v731... is i can set any init.ora parameter....

or something different....

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.

                                                                                           


                    Christopher                                                            

                    Spence               To:     Multiple recipients of list ORACLE-L      

                    <cspence             <ORACLE-L_at_fatcity.com>                            

                    @FuelSpot.com        cc:                                               

                    >                    Subject:     RE: Export - Import from Oracle v8   

                    Sent by: root        to v731                                           

                                                                                           
                                                                                           


                    10/03/2001                                                             

                    12:25 PM                                                               

                    Please                                                                 

                    respond to                                                             

                    ORACLE-L                                                               

                                                                                           
                                                                                           

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: tday6_at_csc.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 Thu Oct 04 2001 - 06:48:57 CDT