>>Could you define large number of tables? The problem could be any number of server-side issues -- available temporary tablespace, available memory, traffic from other users. Then there is the issue of the size of the results set being sent back over the network.
>>
>>The bottom-line problem may be a database design issue [e.g., over normalization of the tables]. You might alleviate the problem by creating a permanent view of more than 1 table in Oracle to act as one of the tables to query from VFP.
>
>Thanks for your response.
>
>I am trying to create the view using 10+ Oracle tables. Everything seems to go fine until I try to save the view. It does not matter whether I am creating the view visually or programatically. That is when everything stops.
>
>I have no control over server-side issues. I am only allowed access to the data base on a read-only basis. But what makes me think that it is not a server issue is that if I use sql pass-thru for the same tables everything works.

The best solution, if you had access to the Oracle database would be to install a view there and then pull that view into a remote view in VFP. You might try this: Create a remote view in VFP for each Oracle table and then do the join in VFP. That's about the only other possiblity I can think of.

Good Luck!

Gregg