OraFAQ Forum: Streams & AQ » deleting a column at the apply process using a DML handler

Home » Server Options » Streams & AQ » deleting a column at the apply process using a DML handler (Oracle 11.x)

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

deleting a column at the apply process using a DML handler [message #602677]

Fri, 06 December 2013 09:57

cotejf
Messages: 1
Registered: December 2013
Location: Canada

Junior Member

Hi guys,
scenario:
source table has a clob column
target table: this column does not exists anymore
DBs: 11.x

When on the SRC database I update this field on this table it tries to apply on the target and I get an error.

I understand that I should remnove the column at the capture but my dba says it can't be done because it is a clob column.

So I have to handle it by myself in the apply handler.

I tried to use the delete_column but it seems that it removes only the data, not the column. The result is that an insert will try to insert WITH that columns and it generates an error.

My question is:
am I missing something? Is there a way to remove the column (old&new) and not only its data?

Thanks in advance

[EDITED by LF: fixed topic title typo; was "hjandler"]

[Updated on: Sat, 07 December 2013 03:03] by Moderator

Report message to a moderator

Previous Topic:	AQ wait time
Next Topic:	Dequeue with RETENTION on queue not working as expected with DELAY

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 20:02:50 CDT 2025