Return-Path: <root@fatcity.cts.com>
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by naude.co.za (8.11.2/8.11.2) with SMTP id g6G8xlp16088
 for <oracle-l@naude.co.za>; Tue, 16 Jul 2002 04:59:47 -0400
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id BAA94512;
 Tue, 16 Jul 2002 01:56:43 -0700 (PDT)
Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 00498DAA; Tue, 16 Jul 2002 01:13:24 -0800
Message-ID: <F001.00498DAA.20020716011324@fatcity.com>
Date: Tue, 16 Jul 2002 01:13:24 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Amjad" <amjad@medicomsoft.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Amjad" <amjad@medicomsoft.com>
Subject: RE: dblink problem ( ORA-02019 )
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: multipart/alternative;	boundary="----=_NextPart_000_0007_01C22CC0.9D9C3BC0"
------=_NextPart_000_0007_01C22CC0.9D9C3BC0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

drop public database link dblink

dear anand iam sorry to say this but such things u can always look up in the
documentation...
no 1 will spoon feed u to such a level....
if its something more logical problem or something that is new we r always
here to help each other out , after all this list is made to help each
other...
i hope u can understand...

thanx and regards,
Amjad.
www.medicomsoft.com

  -----Original Message-----
  From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Anand Kumar
N - Systems
  Sent: Tuesday, July 16, 2002 11:03 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: dblink problem ( ORA-02019 )


  HI AMJAD,
  HOW TO DROP THE DATABASE LINK.

  ANAND
  ITW SIGNODE INDIA LIMITED
    ----- Original Message -----
    From: Amjad
    To: Multiple recipients of list ORACLE-L
    Sent: Thursday, July 11, 2002 1:43 PM
    Subject: RE: dblink problem ( ORA-02019 )


    CREATE  PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY
password USING 'connect_string'

    Regards,
    Amjad.
    www.medicomsoft.com
      : root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Anand Kumar
N - Systems
      Sent: Thursday, July 11, 2002 9:33 AM
      To: Multiple recipients of list ORACLE-L
      Subject: Re: dblink problem ( ORA-02019 )


      Hi all,
      How to Create dblink, can u please explain me.

      bye
      Anand

------=_NextPart_000_0007_01C22CC0.9D9C3BC0
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">


<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D110594907-16072002>drop=20
public database link dblink</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D110594907-16072002></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D110594907-16072002>dear=20
anand iam sorry to say this but such things u can always look up in the=20
documentation...</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D110594907-16072002>no 1=20
will spoon feed u to such a level....</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D110594907-16072002>if its=20
something more logical problem or something that is new we r always here =
to help=20
each other out , after all this list is made to help each=20
other...</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D110594907-16072002>i hope=20
u can understand...</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D110594907-16072002></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D110594907-16072002>thanx=20
and regards,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D110594907-16072002>Amjad.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D110594907-16072002><A=20
href=3D"http://www.medicomsoft.com">www.medicomsoft.com</A></SPAN></FONT>=
</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D110594907-16072002></SPAN></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root@fatcity.com=20
  [mailto:root@fatcity.com]<B>On Behalf Of </B>Anand Kumar N -=20
  Systems<BR><B>Sent:</B> Tuesday, July 16, 2002 11:03 AM<BR><B>To:</B> =
Multiple=20
  recipients of list ORACLE-L<BR><B>Subject:</B> Re: dblink problem ( =
ORA-02019=20
  )<BR><BR></DIV></FONT>
  <DIV><FONT color=3D#000080 face=3D"Century Gothic" size=3D2>HI =
AMJAD,</FONT></DIV>
  <DIV><FONT color=3D#000080 face=3D"Century Gothic" size=3D2>HOW TO =
DROP THE DATABASE=20
  LINK.</FONT></DIV>
  <DIV><FONT color=3D#000080 face=3D"Century Gothic" =
size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT color=3D#000080 face=3D"Century Gothic" =
size=3D2>ANAND</FONT></DIV>
  <DIV><FONT color=3D#800000 face=3D"Century Gothic" size=3D2>ITW =
SIGNODE INDIA=20
  LIMITED</FONT></DIV>
  <BLOCKQUOTE dir=3Dltr=20
  style=3D"BORDER-LEFT: #000080 2px solid; MARGIN-LEFT: 5px; =
MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
    <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
    <DIV=20
    style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
    <A href=3D"mailto:amjad@medicomsoft.com" =
title=3Damjad@medicomsoft.com>Amjad</A>=20
    </DIV>
    <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
    href=3D"mailto:ORACLE-L@fatcity.com" =
title=3DORACLE-L@fatcity.com>Multiple=20
    recipients of list ORACLE-L</A> </DIV>
    <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, July 11, 2002 =
1:43=20
    PM</DIV>
    <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: dblink problem ( =
ORA-02019=20
    )</DIV>
    <DIV><BR></DIV>
    <DIV><FONT color=3D#0000ff><FONT face=3DArial><FONT size=3D2><FONT=20
    size=3D1>CREATE<SPAN class=3D360394606-11072002>&nbsp; </SPAN>PUBLIC =
DATABASE=20
    LINK dblink<SPAN class=3D360394606-11072002> </SPAN>CONNECT TO user =
IDENTIFIED=20
    BY password USING =
'connect_string'<BR></FONT></FONT></FONT></FONT><FONT=20
    color=3D#0000ff><FONT face=3DArial><FONT size=3D2><SPAN=20
    class=3D360394606-11072002></SPAN></FONT></FONT></FONT></DIV>
    <DIV><FONT color=3D#0000ff><FONT face=3DArial><FONT size=3D2><SPAN=20
    =
class=3D360394606-11072002>Regards,</SPAN></FONT></FONT></FONT></DIV>
    <DIV><FONT color=3D#0000ff><FONT face=3DArial><FONT size=3D2><SPAN=20
    =
class=3D360394606-11072002>Amjad.&nbsp;</SPAN></FONT></FONT></FONT></DIV>=

    <DIV><FONT color=3D#0000ff><FONT face=3DArial><FONT size=3D2><SPAN=20
    class=3D360394606-11072002><A=20
    =
href=3D"http://www.medicomsoft.com">www.medicomsoft.com</A></SPAN></FONT>=
</FONT></FONT></DIV>
    <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
      <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
      size=3D2><B>:</B> <A =
href=3D"mailto:root@fatcity.com">root@fatcity.com</A>=20
      [mailto:root@fatcity.com]<B>On Behalf Of </B>Anand Kumar N -=20
      Systems<BR><B>Sent:</B> Thursday, July 11, 2002 9:33 =
AM<BR><B>To:</B>=20
      Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: dblink =
problem=20
      ( ORA-02019 )<BR><BR></DIV></FONT>
      <DIV><FONT color=3D#000080 size=3D2>Hi all,</FONT></DIV>
      <DIV><FONT color=3D#000080 size=3D2>How to Create dblink, can u =
please explain=20
      me.</FONT></DIV>
      <DIV><FONT color=3D#000080 size=3D2></FONT>&nbsp;</DIV>
      <DIV><FONT color=3D#000080 size=3D2>bye</FONT></DIV>
      <DIV><FONT color=3D#000080=20
size=3D2>Anand</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY>=
</HTML>

------=_NextPart_000_0007_01C22CC0.9D9C3BC0--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Amjad
  INET: amjad@medicomsoft.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@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).

