Doug,
How much data is being pulled down to the client? Are you using a SPT statement or a remote view?
If you are dumping large amounts of data it's better to use something like BCP.
>We are getting the 'Not Enough Memory For File Map' error message while running a query against a Oracle DB view. We have boosted the main memory from 500Meg to 1G, and changed the virtual memory to 3G with no success.
>
>In addition, we have monitored the on-going query and it begins by getting records at a decent clip with low CPU usage...then after 20 minutes or so (WHAM), the CPU utilization on the client (VFP) is slammed to the max and records stop being transferred (with Oracle indicating it is waiting for the client to be ready to receive more records).
>
>Any ideas on what to try next?