Home » Server Options » Streams & AQ » How to perform this in Oracle Stream.
How to perform this in Oracle Stream. [message #75661] Mon, 12 January 2004 21:18
Vidyanand More
Messages: 35
Registered: January 2003
Member
Hi All,
Environment Details is as follows:
Oracle : 9.2.0.4 on windows NT environment.
My requirement is as follows:
Scott.emp is identified as source table, i need to identify rows on daily basis from the table for Insert/Update & Delete into another table let us say scott.emp_change in different oracle sid. Emp_change table consist of columns same as scott.emp table i.e. source table, except 2 additional columns update_type (I - Insert, U - Update & D - Delete) & transn_date default sysdate.
Can i perform this using Rule i.e. Can i define rules to identify Insert / Update & Delete of rows from source table scott.emp?

If answer to above question is 'Yes', can someone please provide me example?

Thanks in Advance.
Regards,
Vidyanand
Previous Topic: Oracle Database version for Oracle Streams.
Next Topic: Oracle Streams Configuration
Goto Forum:
  


Current Time: Fri Mar 29 01:11:41 CDT 2024