DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: export table from ORACLE to SYBASE

  1. #1
    Join Date
    Nov 2002
    Location
    London, UK
    Posts
    13

    export table from ORACLE to SYBASE

    Hello,

    Can anyone please help me in exporting data from ORACLE 8.1 to Sybase 12.0. The table is in ORACLE & I want to transfer data to Sybase table.

    Cheers.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    You need to extract data from Oracle and upload it to Sybase.
    You can spool the data from sqlplus (rather slow) or you can use an unload utility such as BMC's Unload for Oracle (very expensive).
    There is a free tool called granger unload (available at http://www.datatransformations.com/download.htm) and it is very helpfull.

    Simply extract data from oracle tables and use the Sybase BCP utility to load the data.

    Cheers,
    R.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Nov 2002
    Location
    London, UK
    Posts
    13
    Cheers.

  4. #4
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    There's an article:
    http://www.eweek.com/article2/0,3959,293,00.asp

    You can read about benchmarks at:
    http://www.tpc.org
    Cheers!
    Cheers!
    OraKid.

  5. #5
    Join Date
    Aug 2004
    Posts
    3
    Originally posted by rotem_fo
    Hi,
    You need to extract data from Oracle and upload it to Sybase.
    You can spool the data from sqlplus (rather slow) or you can use an unload utility such as BMC's Unload for Oracle (very expensive).
    There is a free tool called granger unload (available at http://www.datatransformations.com/download.htm) and it is very helpfull.

    Simply extract data from oracle tables and use the Sybase BCP utility to load the data.

    Cheers,
    R.
    There is another third party product FastReader from WisdomForce. www.wisdomforce.com. FastReqaader allowing unload large oracle tables into text file and creates input for loaders like sql loader* or others. Hope it helps

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by rotem_fo
    You can spool the data from sqlplus (rather slow) . . .
    This is slow if you send the data across the network. You could perhaps run SQLPLUS on the server, or write files with UTL_FILE (no newtork layers getting in the way). But if the free utility fits the bill, no need.

Posting Permissions

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


Click Here to Expand Forum to Full Width