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
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