RE: Oracle-->SQL Server Data transfer

look into UTL_FILE package.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Harvinder Singh [mailto:Harvinder.Singh@xxxxxxxxxxxxx]
Sent: Wednesday, September 29, 2004 1:42 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle-->SQL Server Data transfer


Hi,

We need to transfer large amount of data daily from Oracle database to
SQL Server Database. We have 3 options:
Use DTS of SQL Server
Use Linked server of SQL Server
Use BCP in SQL Server

First 2 options are working but since bcp is very fast we are more
inclinded in using this feature. Since bcp is available in both Sybase
and SQL Server for that 2 databases to transfer data is easy. So we are
looking of how to extract data from Oracle table and put in flat file in
text format. Since exp and expdp data can only be read by imp and impdp,
we only left with spool out using select * from format.
Is there any other fast option available in Oracle to write to text file
that can be readable by other databases?

Thanks
--Harvinder


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: