Re: Can we do column level replication using Oracle streams?

"Vinh" <huuvinh_at_gmail.com> a écrit dans le message de news:1109158367.131593.238040_at_z14g2000cwz.googlegroups.com...
| Hi,
| Can we do column level replication using Oracle streams?
| E.g. table A has 5 columns, I need to replicate 2 columns of table A
| only!
|
| Thanks
| Vinh
|

Yes, you can.
You have to use a dml handler to remove the columns from the LCR with the method lcr.delete_column.

For an example of DML handler use, have a look at "Oracle9i Streams" chapter 20 "Single Database Capture and Apply Example":
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96571/capappdemo.htm#64404

For the LCR$_ROW_RECORD type, have a look at: "Supplied PL/SQL Packages and Types Reference", Chapter 108 "Logical Change Record Types": http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/t_lcr.htm#1007284

Regards
Michel Cadot Received on Wed Feb 23 2005 - 11:36:27 CST