RE: Export - Import from Oracle v8 to v731

> If you have not yet created the export, you need to create the export from
> the v7 system, using the v7 export executable, with a connect string to
> the v8 database.
>
>
> In the version 8 database, run the script
> $HOME/rdbms/admin/catexp7.sql
> as user sys. (I don't believe this is critical, but it can't hurt.)
>
> On the v7 database, export from the v8 database using a connect string
>
> $ exp sys/pwd_at_db owner=scott file=scott.dmp
>
> Good luck!
> Barb
>
>
> ----------
> From: Nirmal Kumar Muthu Kumaran[SMTP:NIRMALK_at_qtel.com.qa]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, October 04, 2001 6:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Export - Import from Oracle v8 to v731
>
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: bakerb_at_rockymountainnews.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).