Hi Tom,

I want to create a DB link to fetch the data from various views from schema 1 and get load into whichever table created in schema2. Also I want to update the table periodically to using daily jobs.

Please help to achieve this.

Example:

Schema A: view1, view2 (Fetch few colums from view 1 and view 2)

schema B: Created a table A based on view 1 & View2 from schema A.

Created DB link in schema B to fetch the view1 &view2

Now I want to store procedure to insert the record store in schemaB. TableA using view1 & view2 (Schema A)

Thanks
Meyyappan

create or replace
procedure MY_PROC is
begin
  insert into schemaB.tablesA
  select * 
  from view1@dblink, view2@dblink
   where view1.pk = view2.pk
end;
/