1. create dblink for each database 2. create or replace view view_name as select * from [EMAIL PROTECTED] union all select * from [EMAIL PROTECTED] union all select * from [EMAIL PROTECTED];
On Nov 26, 2007 3:38 PM, mm kk <[EMAIL PROTECTED]> wrote: > i need syntax to build view that retrive from multiple database > > --------------------------------- > Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try > it now. > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
