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