966949 wrote:Are you sure you need to duplicate the data in another table? That sounds like a bad design. This is what views are designed for.
Please excuse me..
It's my understanding problem.. it's not a view... it's is some other table in other Schema..
Now the requirement is if the columns in EMP table in SCOTT schema got updated/Inserted/deleted then immediately the other table XYZ in Other schema will automatically updated with the same data which is available in EMP table for those columns.
966949 wrote:Why is it necessary for the same data to be in 2 places? What business requirement does that meet? Why couldn't you do it some other way, for example, by including some data from EMP in XYZ_VW?
Please find my below requirement.
I have EMP tale in SCOTT Schema.
in some other schema XYZ i have a view called XYZ_VW based on the table ABC.
in EMP( Scott Schema) and ABC ( XYZ Schema) some columns are equal.
if you are updating any data in the EMP table, the data for the related columns in the table ABC also should update automatically. But here it's not happening.
if I see the data in back end for EMP table I am able to see the updated data but am not able to see the latest data in ABC table in front end, means data is not getting updated.Are you expecting it to be updated? Do you already have a trigger on EMP?
So now I want to see the latest data in EMP table (SCOTT Schema) and ABC Table (XYZ Schema) for the the same columns at a time once the modifications done. So please let me know how it will happen ?Sorry, no. You've sketched one possible way to meet some business requirement. I still don't know what that requirement is, so I don't know if the plan you've described will do what you need or not, or if there's a much better way to meet that requirement.
Hope you got my requirement. Please let me knwo still you require more info.
966949 wrote:Sorry, as long as I don't know what your requirements are, I can't help you meet them.
This is my business requirement. I didn't write any triggers... I have to write any triggers if required... so don't have any other options to explain..
these are the options/requirements I have as of now?