>When I try to create a parametized view using a large number of tables from an Oracle database everything comes to a screeching halt. My PC runs Windows NT with 128 MB memory. The network is Novell. Any ideas would be helpful.

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.