| 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: Exp from 8.1.6 and imp to 7.3.4
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_01C068CC.8088BA50
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
this is an extract from a metalink doc:
Release 8.0 Release 7.3 Run: catexp7.sql as SYS on O8, then use
exp73.exe
Release 8.1 Release 7.3 Run: catexp7.sql as SYS on 8.1 then use
exp73.exe
Release 8.1 Release 8.0 Run: exp80.exe, imp80.exe
On Windows NT there is a known bug for exporting from O8.1 to O7, you get connect by loop error message when exporting view-s. There should be a patch available on metalink for this problem since Dec 11. 2000.
Regards,
Tamas Szecsy
Geometria GIS Sys. House Ltd.
[Szecsy Tamas] -----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com]
Sent: Friday, December 15, 2000 7:07 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Exp from 8.1.6 and imp to 7.3.4
Shoudn't one first run catexp7 script on 8.1.6 before trying to use 7.3.4 export utility?
Alex Hillman
-----Original Message-----
From: ddorr.cs_at_clearstream.com [ mailto:ddorr.cs_at_clearstream.com
<mailto:ddorr.cs_at_clearstream.com> ]
Sent: Friday, December 15, 2000 6:57 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Exp from 8.1.6 and imp to 7.3.4
On the export destination server - that contains your 7.3.4 database -, run exp SCOTT/TIGER_at_ORA816 : this will export your data through SQL*Net.
> ----------
> From: raman.yagna_at_db.com[SMTP:raman.yagna_at_db.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, December 15, 2000 10:06
> To: Multiple recipients of list ORACLE-L
> Subject: Exp from 8.1.6 and imp to 7.3.4
>
> Hi,
> Oracle is not supporting the above mentioned. I came to know of a
> work around . i.e
>
> 1. Run catexp7.sql
> 2.Use exp of version 7.3.4 and take a export .
>
> But in one of my production machine only Oracle 8.1.6 is installed .
> Without Oracle 7.3.4 installed can i do the step 2. If i can what all the
> steps. I'm going to raise a tar with OWS. But I want the gurus comment on
> this subject.
>
> Thanks in anticipation,
> Raman
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
> --
> Author:
> INET: raman.yagna_at_db.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 <http://www.orafaq.com> -- Author: INET: ddorr.cs_at_clearstream.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_01C068CC.8088BA50 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: Exp from 8.1.6 and imp to 7.3.4</TITLE> <META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD> <BODY> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New">Hi,</FONT></SPAN></DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New">this is an extract from a metalink doc:</FONT></SPAN></DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New"></FONT></SPAN> </DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face="Courier New">Release 8.0 <SPAN class=299290808-18122000> </SPAN> Release 7.3 <SPAN class=299290808-18122000> Run</SPAN>: catexp7.sql <SPAN class=299290808-18122000>as </SPAN>SYS <SPAN class=299290808-18122000>on O8, then use </SPAN>exp73.exe <BR>Release 8.1 <SPAN class=299290808-18122000> </SPAN> Release 7.3 <SPAN class=299290808-18122000> Run: </SPAN>catexp7.sql <SPAN class=299290808-18122000>as </SPAN>SYS <SPAN class=299290808-18122000>on 8.1 then use ex</SPAN>p73.exe <BR>Release 8.1 <SPAN class=299290808-18122000> </SPAN>Release 8.0 <SPAN class=299290808-18122000> Run:</SPAN> exp80.exe, imp80.exe<BR> </FONT></DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New" size=2>On Windows NT there is a known bug for exporting from O8.1 to O7, you get connect by loop error message when exporting view-s. There should be a patch available on metalink for this problem since Dec 11. 2000.</FONT></SPAN></DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New" size=2></FONT></SPAN> </DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New" size=2>Regards,</FONT></SPAN></DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New" size=2></FONT></SPAN> </DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New" size=2>Tamas Szecsy</FONT></SPAN></DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><SPAN class=299290808-18122000><FONT face="Courier New" size=2>Geometria GIS Sys. House Ltd.</FONT></SPAN></DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma><BR><FONT size=2><SPAN class=299290808-18122000><FONT face=Arial color=#0000ff>[Szecsy Tamas] </FONT></SPAN>-----Original Message-----<BR><B>From:</B> Alex Hillman [mailto:alex_hillman_at_physia.com]<BR><B>Sent:</B> Friday, December 15, 2000 7:07 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Exp from 8.1.6 and imp to 7.3.4<BR><BR></DIV></FONT></FONT> <P><FONT size=2>Shoudn't one first run catexp7 script on 8.1.6 before trying to use 7.3.4 export utility?</FONT> </P> <P><FONT size=2>Alex Hillman</FONT> </P> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: ddorr.cs_at_clearstream.com [<A href="mailto:ddorr.cs_at_clearstream.com">mailto:ddorr.cs_at_clearstream.com</A>]</FONT> <BR><FONT size=2>Sent: Friday, December 15, 2000 6:57 AM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE: Exp from 8.1.6 and imp to 7.3.4</FONT> </P><BR> <P><FONT size=2>On the export destination server - that contains your 7.3.4 database -, run</FONT> <BR><FONT size=2>exp SCOTT/TIGER_at_ORA816 : this will export your data through SQL*Net. </FONT></P> <P><FONT size=2>> ----------</FONT> <BR><FONT size=2>> From: raman.yagna_at_db.com[SMTP:raman.yagna_at_db.com]</FONT> <BR><FONT size=2>> Reply To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT size=2>> Sent: Friday, December 15, 2000 10:06</FONT> <BR><FONT size=2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>> Subject: Exp from 8.1.6 and imp to 7.3.4</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> Hi,</FONT> <BR><FONT size=2>> Oracle is not supporting the above mentioned. I came to know of a</FONT> <BR><FONT size=2>> work around . i.e</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> 1. Run catexp7.sql</FONT> <BR><FONT size=2>> 2.Use exp of version 7.3.4 and take a export .</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> But in one of my production machine only Oracle 8.1.6 is installed .</FONT> <BR><FONT size=2>> Without Oracle 7.3.4 installed can i do the step 2. If i can what all the</FONT> <BR><FONT size=2>> steps. I'm going to raise a tar with OWS. But I want the gurus comment on</FONT> <BR><FONT size=2>> this subject.</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> Thanks in anticipation,</FONT> <BR><FONT size=2>> Raman</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> </FONT><BR><FONT size=2>> -- </FONT><BR><FONT size=2>> Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com</A></FONT> <BR><FONT size=2>> -- </FONT><BR><FONT size=2>> Author: </FONT><BR><FONT size=2>> INET: raman.yagna_at_db.com</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>> San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>> --------------------------------------------------------------------</FONT> <BR><FONT size=2>> To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>> the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>> (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>> also send the HELP command for other information (like subscribing).</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: </FONT><BR><FONT size=2> INET: ddorr.cs_at_clearstream.com</FONT> </P> <P><FONT size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>--------------------------------------------------------------------</FONT> <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>alsoReceived on Mon Dec 18 2000 - 02:28:28 CST
 |
 |