OraFAQ Forum: Streams & AQ » How to delete a column from LCR in Oracle 9i

Home » Server Options » Streams & AQ » How to delete a column from LCR in Oracle 9i (Oracle 9i, AIX)

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

How to delete a column from LCR in Oracle 9i [message #315578]

Tue, 22 April 2008 00:55

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.

Report message to a moderator

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

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

rsethy
Messages: 11
Registered: February 2008

Junior Member

Thanks.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 19 23:08:04 CDT 2025