OraFAQ Forum: Streams & AQ » How to perform this in Oracle Stream.

Home » Server Options » Streams & AQ » How to perform this in Oracle Stream.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	Oracle Database version for Oracle Streams.
Next Topic:	Oracle Streams Configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 20:05:29 CST 2024