FAQ
Does anyone have an example of connecting to a remote database without a
database link? I think that I have seen it done before by putting in the
username and password and tnsnames connection information right into the select
statement. Can it be done?


Tom

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Terrian, Tom (Contractor) (DAASC)
INET: Tom.Terrian_at_dla.mil

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

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).

Search Discussions

  • Stephen Lee at Sep 16, 2003 at 3:29 pm
    The COPY command does NON-dblink connect to the remote database.

    -----Original Message-----

    Does anyone have an example of connecting to a remote database without a
    database link? I think that I have seen it done before by putting in the
    username and password and tnsnames connection information right into the
    select statement. Can it be done?

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Stephen Lee
    INET: Stephen.Lee_at_DTAG.Com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    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).
  • Stephane Paquette at Sep 16, 2003 at 4:04 pm
    MessageYou can always use sqlplus copy command to bring back some data
    without a db link.

    Stephane Paquette
    Administrateur de bases de donnees

    Database Administrator

    Standard Life

    www.standardlife.ca

    Tel. (514) 499-7999 7470 and (514) 925-7187

    stephane.paquette_at_standardlife.ca

    -----Original Message-----
    From: ml-errors_at_fatcity.com On Behalf Of
    Terrian, Tom (Contractor) (DAASC)
    Sent: Tuesday, September 16, 2003 11:15 AM
    To: Multiple recipients of list ORACLE-L
    Subject: Connect to a remote database without a link

    Does anyone have an example of connecting to a remote database without a
    database link? I think that I have seen it done before by putting in the
    username and password and tnsnames connection information right into the
    select statement. Can it be done?

    Tom

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Stephane Paquette
    INET: stephane.paquette_at_standardlife.ca

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    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).
  • Pete Finnigan at Sep 16, 2003 at 4:44 pm
    Hi Stephen,

    The COPY command is a SQL*Plus command and allows SQL*Plus to act as a
    "pipe" for want of a better description between two databases to copy
    data. It is deprecated as far as I know? and i don't think it handles
    some of the newer data types.

    I think the OP meant from within SQL rather than SQL*Plus.

    kind regards

    Pete

    In article, Stephen Lee
    writes
    The COPY command does NON-dblink connect to the remote database.

    -----Original Message-----
    --
    Pete Finnigan
    email:pete_at_petefinnigan.com
    Web site: http://www.petefinnigan.com - Oracle security audit specialists
    Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Pete Finnigan
    INET: oracle_list_at_peterfinnigan.demon.co.uk

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    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).
  • Stephen Lee at Sep 16, 2003 at 4:59 pm
    Deprecated? Already? That sure didn't last long.

    As far as what data types, I think it is whatever you can grab with a select
    statement. If you have long datatype, you need to do a
    set long 12345 (or whatever)

    other stuff to set are
    set arraysize 100 (or whatever)
    set copycommit 1000 (or whatever)

    I like the command. It seems to do a decent job of hauling over sizable
    chunks of data.
    -----Original Message-----
    From: Pete Finnigan
    Sent: Tuesday, September 16, 2003 11:45 AM
    To: Multiple recipients of list ORACLE-L
    Subject: Re: Connect to a remote database without a link


    Hi Stephen,

    The COPY command is a SQL*Plus command and allows SQL*Plus to act as a
    "pipe" for want of a better description between two databases to copy
    data. It is deprecated as far as I know? and i don't think it handles
    some of the newer data types.

    I think the OP meant from within SQL rather than SQL*Plus.

    kind regards

    Pete

    In article, Stephen Lee
    writes
    The COPY command does NON-dblink connect to the remote database.

    -----Original Message-----
    --
    Pete Finnigan
    email:pete_at_petefinnigan.com
    Web site: http://www.petefinnigan.com - Oracle security audit
    specialists
    Book:Oracle security step-by-step Guide - see
    http://store.sans.org for details.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Pete Finnigan
    INET: oracle_list_at_peterfinnigan.demon.co.uk

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    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.net
    --
    Author: Stephen Lee
    INET: Stephen.Lee_at_DTAG.Com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 16, '03 at 3:15p
activeSep 16, '03 at 4:59p
posts5
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase