Insert data to another schema
401226Oct 27 2003 — edited Oct 29 2003I have two database VAT and TIN within one SGA with having scott/tiger user each. Now I want to insert data from EMP table of scott/tiger@VAT user to EMP table of scott/tiger@TIN user when I am logon as scott/tiger@VAT through SQL Plus or any *.fmb file instantly on commit from *.fmb of scott/tiger@VAT.
Any idea will be highly appreciated.