First, the amount of data should not be the problem.

Second, since you are using those earlier version of the ODBC drivers, I would immediatley switch to the MS ODBC Driver for Oracle [MDAC] free from MS.

What version of VFP and SP?

>Requerying same remote view(Oracle) generate the error below. The first try is O.K but the second is always telling fatal system error and shut the application down.
>
>I suspect a couple of things causing App shut down.
>
>1. The amount of data retrieved is too large? Record count is approximately 12,000 and 2Megabyte
>
>2. The version of ODBC ? ( Oracle 72 ,1996 )
> VB ADO with Oracle73 seems to slightly faster than VFP with Oracle at least retrieving the remote data. Later I'll give it a
> try with Oracle73ODBC.
>
>3. Configuration file ( temp = ...) was excluded.
>
>Anyway the error text is as below and it's like something similar to that occured sometimes using Microsoft Excel..
>I would like to thank anyone who respond me.
>
>04x!:1005fa56 MODULE VFP500.DLL.. SM(Exe file Name) EXCEPTION(?) 10H
>Registers:
>EAX=0000177f CS=015f EIP=1005fa56 EFLGS=00010202
>EBX=00000000 SS=0167 ESP=0063b6fc EBP=00000000
>ECX=00000000 DS=0167 ESI=00001370 FS=4a8f
>EDX=00001370 ES=0167 EDI=00000002 GS=0000
>BCS:EIP: BYTE NUMBER(?)
>dd 44 24 0c 83 c4 08 5e 83 c4 08 c3 68 ff ff 00
>Stack dump:
>00001370 0000ffff 102fe4f0 00000000 00000000 101919c9 00000000
>3fe00000 0063b7b8 0063b920 0000226b 00000068 00000000 40590000 00000000 00000000