Is there any way to direct the scheduled run of a Materialized view to a specific node in a RAC database? I have a 6 node RAC database running on Sun Solaris and out of that, 1 node is having 8 CPUS whereas all the other nodes are having 4 CPUS each. The Materialized view in question runs every hour, and I would like to make it run only on the node which is having 8 CPUS? Is it possible ? (Using any service or TNS entries or any other method) ??? -- Anurag Verma, Database Administrator ERCOT(Electric Reliability Council of Texas), Texas 76574