Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: imp & exp tool of 8i in 7.3.4 ?

RE: imp & exp tool of 8i in 7.3.4 ?

From: Szecsy Tamas <tszecsy_at_GEOMETRIA.hu>
Date: Wed, 10 Jan 2001 12:38:01 +0100
Message-Id: <10737.126250@fatcity.com>


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_01C07AF9.CCA77830
Content-Type: text/plain;

        charset="windows-1255"

I don't know what catexp is installed on my WinNT oracle 8.1.7 - I did not reconfigure the database that was created by the wizard. All the same I can create an export file using exp73.exe and the dump file is a valid Ora7 dmp file. I did not try to import into 8.1.7 with imp73 though.  

Tamas Szecsy

-----Original Message-----
From: Amar Kumar Padhi [mailto:TS2017_at_emirates.com] Sent: Wednesday, January 10, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: imp & exp tool of 8i in 7.3.4 ?

As per my knowledge, forward compatibility is not provided in exp/imp. and neither can two versions co-exit on the same db.

Thanks,
Amar Kumar Padhi
Software Consultant

-----Original Message-----
From: Yossi Nixon [ mailto:YossiN_at_BEZEQINT.CO.IL <mailto:YossiN_at_BEZEQINT.CO.IL> ]
Sent: Wednesday, January 10, 2001 11:31 AM To: ORACLE Fatcity Mail (E-mail); Oracle LazyDBA Mail (E-mail) Subject: imp & exp tool of 8i in 7.3.4 ?

Hi,
I want to use imp & exp of oracle8i (using the feature QUERY) on oracle 7.3.4

I tried to use it - without running any catxxx.sql and got the following error:

Export: Release 8.1.6.0.0 - Production on Wed Jan 10 09:39:30 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Password:

EXP-00008: ORACLE error 942 encountered 
ORA-00942: table or view does not exist 
EXP-00024: Export views not installed, please notify your DBA 
EXP-00000: Export terminated unsuccessfully 



can it be implemented without harming the exp & imp tools of 7.3.4 (working together)?



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl <http://www.LAZYDBA.com/odbareadmail.pl>

------_=_NextPart_001_01C07AF9.CCA77830
Content-Type: text/html;

        charset="windows-1255"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1255">
<TITLE>RE: imp & exp tool of 8i in 7.3.4 ?</TITLE>

<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=013512311-10012001><FONT face=Arial color=#0000ff size=2>I don't know what catexp is installed on my WinNT oracle 8.1.7 - I did not reconfigure the database that was created by the wizard. All the same I can create an export file using exp73.exe and the dump file is a valid Ora7 dmp file. I did not try to import into 8.1.7 with imp73 though.</FONT></SPAN></DIV> <DIV><SPAN class=013512311-10012001><FONT face=Arial color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=013512311-10012001><FONT face=Arial color=#0000ff size=2>Tamas Szecsy</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
  size=2>-----Original Message-----<BR><B>From:</B> Amar Kumar Padhi   [mailto:TS2017_at_emirates.com]<BR><B>Sent:</B> Wednesday, January 10, 2001 9:05   AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE:   imp &amp; exp tool of 8i in 7.3.4 ?<BR><BR></FONT></DIV>
<P><FONT size=2>As per my knowledge, forward compatibility is not provided in
  exp/imp.</FONT> <BR><FONT size=2>and neither can two versions co-exit on the   same db.</FONT> </P>
<P><FONT size=2>Thanks,</FONT> <BR><FONT size=2>Amar Kumar Padhi</FONT>
<BR><FONT size=2>Software Consultant</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Yossi
  Nixon [<A
  href="mailto:YossiN_at_BEZEQINT.CO.IL">mailto:YossiN_at_BEZEQINT.CO.IL</A>]</FONT>
<BR><FONT size=2>Sent: Wednesday, January 10, 2001 11:31 AM</FONT> <BR><FONT
  size=2>To: ORACLE Fatcity Mail (E-mail); Oracle LazyDBA Mail (E-mail)</FONT>
<BR><FONT size=2>Subject: imp &amp; exp tool of 8i in 7.3.4 ?</FONT> </P><BR>
<P><FONT size=2>Hi,</FONT> <BR><FONT size=2>I want to use imp &amp; exp of
  oracle8i (using the feature QUERY) on oracle</FONT> <BR><FONT size=2>7.3.4
</FONT></P>
<P><FONT size=2>I tried to use it - without running any catxxx.sql and got the
  following</FONT> <BR><FONT size=2>error:</FONT> </P>

<P><FONT size=2>Export: Release 8.1.6.0.0 - Production on Wed Jan 10 09:39:30
2001</FONT> </P>
<P><FONT size=2>(c) Copyright 1999 Oracle Corporation.&nbsp; All rights
reserved.</FONT> </P>

<P><FONT size=2>Password: </FONT></P>
<P><FONT size=2>EXP-00008: ORACLE error 942 encountered</FONT> <BR><FONT
  size=2>ORA-00942: table or view does not exist</FONT> <BR><FONT   size=2>EXP-00024: Export views not installed, please notify your DBA</FONT>
<BR><FONT size=2>EXP-00000: Export terminated unsuccessfully</FONT>
</P><BR><BR>
<P><FONT size=2>can it be implemented without harming the exp &amp; imp tools
  of 7.3.4 (working</FONT> <BR><FONT size=2>together)?</FONT> </P>
<P><FONT size=2>--------</FONT> <BR><FONT size=2>Think you know someone who
  can answer the above question? Forward it to them!</FONT> <BR><FONT size=2>to   unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com</FONT>
<BR><FONT size=2>to subscribe send a blank email to
  oracledba-subscribe_at_LAZYDBA.com </FONT><BR><FONT size=2>Visit the list   archive: <A target=_blank
  href="http://www.LAZYDBA.com/odbareadmail.pl">http://www.LAZYDBA.com/odbareadmail.pl</A></FONT> Received on Wed Jan 10 2001 - 05:38:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US