hi fellows
I need to replicate 4 tables using oracle streams 9.2 version but I'm getting an error regarding this type of tables (function-based index)
Well, in metalink describe this note:
Workarounds for Function-Based Index Datatype Limitation When Using 9.2 Oracle Streams (Doc ID
362811.1)
and the document says as a workaround the following:
It is possible to work around this limitation in 9.2 as follows:
Create triggers on the source table that place rows in a 'shadow table' that contains no unsupported columns, and create
capture rules for this shadow table. Therefore Streams is replicating the shadow table without the function-based indexes to
the destination site, possibly using rule-based transformations or DML handlers to resolve any naming issues.
Well,
Have someone could give an example how can I do this? or someone got this situation on the past?
thank you