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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2003

Added on Oct 27 2003

#general-database-discussions

11 comments

1,661 views