Does SharePlex support virtual columns?
Virtual column is a new feature in Oracle 11g. As long as source and target table are created the same way, it should work fine with SharePlex. This is because the value for the virtual column is derived from existing real columns.
Copy does not work on table with virtual column due to the oracle export limitation on table with virtual column.
Compare works fine on table with virtual column.
SharePlex replicates the underlying columns; the virtual column itself is not seen by Shareplex so the management of it is outside of SharePlex. SharePle treats virtual columns similar to indices on the table.
Object cache dump will not show the virtual column.
