| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export & Import From Nt To Unix
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C019D2.C74DABE0
Content-Type: text/plain;
charset="iso-8859-1"
My understanding that question was how to export data from 7.3 on Solaris to
8.0.4 on NT.
The best thing is to have the same version on NT that you have on Solaris
and do export from 7.3 on Solaris using NT 7.3 export thru the network and
import from this file using 8.0.4 export.
I had a problem to export from 8.1.6 on linux and export to 8.1.6.2 on
solaris. 8.1.6.2 export did not work with 8.1.6 on linux, so I had to
reinstall 8.1.6 on solaris, make an export using 8.1.6 export and import
using 8.1.6.2.
Alex
-----Original Message-----
From: Joseph S. Testa [mailto:teci_at_oracle-dba.com]
Sent: Tuesday, September 05, 2000 1:12 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Export & Import From Nt To Unix
Upgrade solaris version, now that is said,
how do you propose if you've used ANY 8.0 features that oracle will be able to pull in a 8.0 .dmp file?
if i remember correctly oracle will guarantee upward compatibility but NOT downwards. There was WAY too much that changed between 7 and 8.
the best you could hope for would be to do the export on solaris using the v7 exp command, shooting across the network(i'll assume these machines can see each other) and then hoping it dont choke on some 8 feature you've used, like partitioning, etc.
good luck.
joe
Mitchell wrote:
> We have Oracle 8.0.4 on NT platform and want to import data from
> Oracle 7.3 on Solario 7 UNIX. Is there any suggestion on doing this?
>
> Thanks in advance
> Mitchell
> .
>
> --
> Author: Mitchell
> INET: mitchell_at_comnet.ca
>
> 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).
-- Author: Joseph S. Testa INET: teci_at_oracle-dba.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). ------_=_NextPart_001_01C019D2.C74DABE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Export & Import From Nt To Unix</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>My understanding that question was how to export data = from 7.3 on Solaris to 8.0.4 on NT. </FONT> <BR><FONT SIZE=3D2>The best thing is to have the same version on NT = that you have on Solaris and do export from 7.3 on Solaris using NT 7.3 = export thru the network and import from this file using 8.0.4 = export.</FONT></P> <P><FONT SIZE=3D2>I had a problem to export from 8.1.6 on linux and = export to 8.1.6.2 on solaris. 8.1.6.2 export did not work with 8.1.6 on = linux, so I had to reinstall 8.1.6 on solaris, make an export using = 8.1.6 export and import using 8.1.6.2.</FONT></P> <P><FONT SIZE=3D2>Alex</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Joseph S. Testa [<A = HREF=3D"mailto:teci_at_oracle-dba.com">mailto:teci_at_oracle-dba.com</A>]</FON= T> <BR><FONT SIZE=3D2>Sent: Tuesday, September 05, 2000 1:12 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Export & Import From Nt To = Unix</FONT> </P> <BR> <P><FONT SIZE=3D2>Upgrade solaris version, now that is said,</FONT> </P> <P><FONT SIZE=3D2>how do you propose if you've used ANY 8.0 features = that oracle will be</FONT> <BR><FONT SIZE=3D2>able to pull in a 8.0 .dmp file?</FONT> </P> <P><FONT SIZE=3D2>if i remember correctly oracle will guarantee upward = compatibility but NOT</FONT> <BR><FONT SIZE=3D2>downwards. There was WAY too much that changed = between 7 and 8.</FONT> </P> <P><FONT SIZE=3D2>the best you could hope for would be to do the export = on solaris using the</FONT> <BR><FONT SIZE=3D2>v7 exp command, shooting across the network(i'll = assume these machines</FONT> <BR><FONT SIZE=3D2>can see each other) and then hoping it dont = choke on some 8 feature</FONT> <BR><FONT SIZE=3D2>you've used, like partitioning, etc.</FONT> </P> <P><FONT SIZE=3D2>good luck.</FONT> </P> <P><FONT SIZE=3D2>joe</FONT> </P> <BR> <P><FONT SIZE=3D2>Mitchell wrote:</FONT> </P> <P><FONT SIZE=3D2>> We have Oracle 8.0.4 on NT platform and want to = import data from</FONT> <BR><FONT SIZE=3D2>> Oracle 7.3 on Solario 7 UNIX. Is there any = suggestion on doing this?</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Thanks in advance</FONT> <BR><FONT SIZE=3D2>> Mitchell</FONT> <BR><FONT SIZE=3D2>> .</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Mitchell</FONT> <BR><FONT SIZE=3D2>> INET: mitchell_at_comnet.ca</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Joseph S. Testa</FONT> <BR><FONT SIZE=3D2> INET: teci_at_oracle-dba.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Fri Sep 08 2000 - 15:24:18 CDT
 |
 |