HOW TO SAVE DATA FAST
I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad’s save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, (case when old_mdn is null then [...]

Answer Question   |  April 15, 2009  12:46 PM
Oracle Database, Oracle Output Via SQL, Oracle SQL

Spooling Oracle Output via SQL DTS
I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

Answer Question   |  October 16, 2008  4:09 PM
DTS packages, Oracle, Oracle Output Via SQL, SQL Server, Stored Procedures