RE: Export - Import from Oracle v8 to v731

From: <tday6_at_csc.com>
Date: Wed, 03 Oct 2001 09:43:30 -0700
Message-ID: <F001.003A0BB6.20011003093024@fatcity.com>

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 Wed Oct 03 2001 - 11:43:30 CDT