"Cyril" <email@example.com> wrote in message
> I need to copy a table from an 8i oracle database to a sqlserver 2000
> Is it possible to use the command "COPY FROM ... TO ..." ?
> So, what is the correct syntax ?
> Thanks for your help
Look into linked servers in Books Online - you can create a linked server
pointing to the Oracle database, then do this:
insert into dbo.MSSQLTable
select col1, col2, ...
Alternatively, DTS can move data from Oracle to MSSQL.