Re: Remote view - who should create it? - discussion point!

smithp_at_ntlworld.com.notreally (Paul Smith) wrote in message news:<3c61860e.1264608_at_news.ntlworld.com>...
> Thanks for the responses - it transpires that the chap who "owns" the remote
> database is tied by warranty clauses set by the supplier of the database he
> supposedly owns. Adding anything to the schema voids the warranty! That's why I
> can't add the view at his end.
>

Easy: create the view in ANOTHER schema. There is no impact whastoever on the vendor's schema.

And they cannot argue (if the database is ORACLE they most certainly can NOT!) that having a view in another schema affects their schema in any way, shape or format.

If they chose to make a "case", then that's absolute bull and should be challenged. About time vendors stopped using these ludicrous and technically unsustainable clauses to mask the inefficient use of resources by their software!

Cheers
Nuno Souto Received on Sat Feb 09 2002 - 05:32:15 CST