Re: view for database links

From: Mserban <mserban_at_aol.com>
Date: 1997/04/13
Message-ID: <19970413064701.CAA28846@ladder01.news.aol.com>#1/1

If by "...execute query on the view...", you mean to run SELECT * FROM inventory_all, then you will not be able to do that if any of the servers involved in the query is down.

If, on the other side, you just want to CREATE the view regardless of the fact that one or more servers is/are down, you may be able to do that using the FORCE clause in the CREATE [OR REPLACE] VIEW statement, as follows:

CREATE [OR REPLACE] FORCE VIEW inventory_all.....

I hope this helps.

Michael Serbanescu
Sr. Consultant, MIACO CORPORATION Received on Sun Apr 13 1997 - 00:00:00 CDT