This discussion is archived
1 Reply Latest reply: Nov 29, 2012 2:38 PM by Justin Cave RSS

updating the data from one schema to another schema

969952 Newbie
Currently Being Moderated
Hi All,

I have schema called SCOTT. In this I have a table Called EMP. The structure of EMP is as follows.
Create table EMP
ENO   Number,
ID      Varchar2(20),
PAN    VARCHAr2(20),
name  varchar2(20),
location  varchar2(20),
zip    number (8),
mailid   number(8),
Apartment varchar2(20),
roomno    number(8),
corierid  number(8),
corier_person_name  varchar2(30),
Status  varchar2(1)
i have a view EPM_VW in some other schema SYS which is created on 5 tables having related data to EMP table. Now my requirement is if am doing any modifications like INSERT/Update/Delete or any thing on EMP table in SCOTT it should be effectting immediately on the VIEW. Can you please give me your ideas?



  • Correct Answers - 10 points
  • Helpful Answers - 5 points