Home » Server Options » Streams & AQ » How to delete a column from LCR in Oracle 9i (Oracle 9i, AIX)
How to delete a column from LCR in Oracle 9i [message #315578] Tue, 22 April 2008 00:55 Go to next message
rsethy
Messages: 11
Registered: February 2008
Junior Member
I am configuring Oracle streams in Oracle 9i. I have more column in the source database then the destination database. Please guide me how to use rule based trnasformation function using lcr.delete_column to delete the extra column before applying into destination database.

Please send the code.
Re: How to delete a column from LCR in Oracle 9i [message #315597 is a reply to message #315578] Tue, 22 April 2008 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know if it is possible with a rule in 9i but it is possible with a DML handler.
Check Oracle9i Streams, Chapter 20 Single Database Capture and Apply Example, section Configure Capture and Apply, step 9 Create the DML Handler Procedure and change lcr.ADD_COLUMN to lcr.DELETE_COLUMN.

You can also read Metalink note 265867.1, "Example Streams Apply DML Handler Showing the Adding of Columns to the Apply LCR" in the same way.

Regards
Michel
Re: How to delete a column from LCR in Oracle 9i [message #315609 is a reply to message #315597] Tue, 22 April 2008 03:06 Go to previous message
rsethy
Messages: 11
Registered: February 2008
Junior Member
Thanks.
Previous Topic: Propagating only the required data to destination
Next Topic: How to handle UPDATE dml opration in add_subset_rule(Oracle Streams) (merged)
Goto Forum:
  


Current Time: Fri Mar 29 10:54:38 CDT 2024