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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-25 : 07:38:40
|
| Padraig writes "I have created DTS Package to get data from an old unix db using odbc which takes aproximately 20 minutes on a bad day. I then carry out some data modification. However when I export my data to an Oracle Dataware house it takes 4hrs, does anyone have any idea why this is happening ?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-25 : 12:50:44
|
| When you say "when I export my data to an Oracle Dataware", do you mean that you are transferring the data from SQL Server into Oracle? To make the export quicker, just drop all of the indexes in the Oracle database, then recreate them after the data has been exported. This always helps make the transfer faster.Tara |
 |
|
|
|
|
|
Copy to Oracle