RE: Database link giving ora-12663...

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Fri, 20 Oct 2000 16:39:16 +0400
Message-Id: <10655.119836@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_01C03A92.C287F4A0
Content-Type: text/plain;

charset="x-user-defined"
Content-Transfer-Encoding: quoted-printable

Hi,
thanks. I am able to select from emp table through the link but unable = to
describe. why not?
I am able to describe a table when I use a link between two oracle 7.3 databases.

Thanks,=20
Amar=20
00-971-50-7883254=20
ts2017_at_emirates.com=20
amar_padhi_at_hotmail.com=20
amar_padhi_at_musclemail.com=20

=20

-----Original Message-----
From: Cl=E1udio Monegatto [mailto:claudio.monegatto_at_hcnet.usp.br] Sent: Friday, October 20, 2000 4:25 PM
To: Amar Kumar Padhi
Subject: RE: Database link giving ora-12663...

Execute this command in this SQLplus (Client) and not=20 from console server, or other command,=20 execute (select* from EMP_at_DB7_LINK).
=20
The command DESC with DBLINK not execute in sqlplus in the server. =20
Cl=E1udio Monegatto
Centro de Inform=E1tica HCFMUSP
claudio.monegatto_at_hcnet.usp.br <mailto:claudio.monegatto_at_hcnet.usp.br>=20 Fone: 3069-7104
=20

-----Original Message-----
From: Amar Kumar Padhi [mailto:TS2017_at_emirates.com] Sent: Sexta-feira, 20 de Outubro de 2000 10:13 Subject: Database link giving ora-12663...

Hi,=20
I created a database link from Oracle 8i database to a 7.3.4.3.0 = database as
below:=20

------_=_NextPart_001_01C03A92.C287F4A0
Content-Type: text/html;

charset="x-user-defined"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=x-user-defined">


<TITLE>Database link giving ora-12663...</TITLE>
<META content='"MSHTML 4.72.3713.2800"' name=GENERATOR>
</HEAD>

<BODY>
<DIV><SPAN class=534283312-20102000><FONT color=#0000ff face="Courier New" size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=534283312-20102000><FONT color=#0000ff face="Courier New" size=2></FONT></SPAN><SPAN class=534283312-20102000><FONT color=#0000ff face="Courier New" size=2>thanks. I am able to select from emp table through the link but unable to describe. why not?</FONT></SPAN></DIV> <DIV><SPAN class=534283312-20102000><FONT color=#0000ff face="Courier New" size=2></FONT></SPAN><SPAN class=534283312-20102000><FONT color=#0000ff face="Courier New" size=2>I am able to describe a table when I use a link between two oracle 7.3 databases.</FONT></SPAN></DIV> <P><FONT color=#000000 face="Courier New" size=2>Thanks,</FONT> <BR><B><FONT

color=#000000 face="Courier New" size=2>Amar</FONT><I></I></B> <BR><FONT 
color=#008080 face="Courier New" size=2>00-971-50-7883254</FONT> <BR><FONT 
color=#008080 face="Courier New" size=2>ts2017_at_emirates.com</FONT> <BR><FONT 
color=#008080 face="Courier New" size=2>amar_padhi@</FONT><B><FONT color=#008080 
face="Courier New" size=2>hot</FONT></B><FONT color=#008080 face="Courier New" 
size=2>mail.com</FONT> <BR><FONT color=#008080 face="Courier New" 
size=2>amar_padhi@</FONT><B><FONT color=#008080 face="Courier New"

size=2>muscle</FONT></B><FONT color=#008080 face="Courier New" size=2>mail.com</FONT> </P>
<DIV> </DIV>
<BLOCKQUOTE>

<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
    size=2>-----Original Message-----<BR><B>From:</B> Cláudio Monegatto     [mailto:claudio.monegatto_at_hcnet.usp.br]<BR><B>Sent:</B> Friday, October 20,     2000 4:25 PM<BR><B>To:</B> Amar Kumar Padhi<BR><B>Subject:</B> RE: Database     link giving ora-12663...<BR><BR></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
    class=780022312-20102000>Execute this command in this SQLplus (Client) and     not </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
    class=780022312-20102000>from console server, or other command,
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
    class=780022312-20102000>execute (select* from     EMP_at_DB7_LINK).</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
    class=780022312-20102000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
    class=780022312-20102000>The command DESC with DBLINK not execute in sqlplus     in the server.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
    class=780022312-20102000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2>Cláudio Monegatto</FONT></DIV>
<DIV><FONT face=Arial size=2>Centro de Informática
    HCFMUSP</FONT></DIV>
<DIV><FONT face=Arial size=2><A

    href="mailto:claudio.monegatto_at_hcnet.usp.br">claudio.monegatto_at_hcnet.usp.br</A></FONT></DIV>
<DIV><FONT face=Arial size=2>Fone: 3069-7104</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE

    style="BORDER-LEFT: #0000ff solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">

        <DIV class=OutlookMessageHeader><FONT face="Times New Roman" 
        size=2>-----Original Message-----<BR><B>From:</B> Amar Kumar Padhi 
        [mailto:TS2017_at_emirates.com]<BR><B>Sent:</B> Sexta-feira, 20 de Outubro 
        de 2000 10:13<BR><B>Subject:</B> Database link giving 
        ora-12663...<BR><BR></DIV></FONT><BR><BR>
        <P><FONT face="Courier New" size=2>Hi,</FONT> <BR><FONT 
        face="Courier New" size=2>I created a database link from Oracle 8i

Received on Fri Oct 20 2000 - 07:39:16 CDT