Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: bcp in/out Oracle Linked Server

    Is this possible?

    Has anyone done this?

    Any comments appreciated.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: bcp in/out Oracle Linked Server

    Brett:

    Sorry for being thick, but your question wasn't entirely clear to me:

    Are you trying to use BCP on a linked Oracle server to dump a file from a command in SQL server? or

    Are you trying to bulk load a table in Oracle with data in SQL (and vice-versa)?

    Regards,

    hmscott

  3. #3
    Join Date
    Sep 2003
    Posts
    522
    bcp out is possible:

    you can create a procedure/function/view referencing the ora object and use queryout with your bcp using your procedure/function/view.

    i haven't tried bcp'ing in into a linked server yet, but you can do a test yourself, right ?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Guys,

    Thanks...

    Sorry for not being clear...

    I want to set up a generic (yes...dynamic sql against the catalog) to bcp out all tables (and gener format cards for fixed width).

    That's built for sql server.

    I want to establish a linked server, and point the sprocs at the linked server (Oracle, udb, whatever).

    I was hoping to avoid queryout (that's why I gener the format cards)..

    And yes, I can (and will test) the bcp back in...

    I'm thinking I might have to gener view of the tables on the linked server..

    Another question, how do you reference INFORMATION_SCHEMA of another database (in this case the linked server) from the context of the database you're in?

    EDIT: Other responses http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31183
    Last edited by Brett Kaiser; 12-10-03 at 10:08.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: bcp in/out Oracle Linked Server

    Originally posted by hmscott
    Brett:

    Sorry for being thick, but your question wasn't entirely clear to me:

    Are you trying to use BCP on a linked Oracle server to dump a file from a command in SQL server? or

    Are you trying to bulk load a table in Oracle with data in SQL (and vice-versa)?

    Regards,

    hmscott
    fyi...It's SQLLoader in Oracle....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •