Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert data to another schema

401226Oct 27 2003 — edited Oct 29 2003
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2003
Added on Oct 27 2003
11 comments
1,661 views