Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
haribabu68
Starting Member
1 Post |
 Posted - 2008-02-27 : 05:05:22
|
| Hi,We are trying to export data to Oracle using DTS & an ODBC connection - this is too slow!!Can we also try using a text dump in SQL and then use Oracle SQL Loader to load from text file?If so how do we make a text dump from SQL using a DTS - here we are not dumping full tables but data in a particular date range?ThanksHari. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-27 : 05:16:46
|
| You use BCP to dump out query output in the format of data file which you can import in the Oracle.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Exporting data to Oracle