Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to copy table from oracle database to sqlserver database ?

Re: How to copy table from oracle database to sqlserver database ?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 10 Aug 2004 19:44:11 +0200
Message-ID: <ha2ih01cppcf2gtc8b5pamm5amn4r7f5j1@4ax.com>


On 10 Aug 2004 07:15:16 -0700, jewelk_at_free.fr (Cyril) wrote:

>Hello,
>
>I need to copy a table from an 8i oracle database to a sqlserver 2000 database.
>
>Is it possible to use the command "COPY FROM ... TO ..." ?
>So, what is the correct syntax ?
>
>
>Thanks for your help
>
>Cyril

Read up on using the Heterogeneous Gateway to Sqlserver.

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Aug 10 2004 - 12:44:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US