Hi All,

I have a requirement where One of the parent table is in one schema (SchemaA) and child table is in SchemaB. Instead of going on a global RevInfo due to 500 schemas. I have decided to go with one RevInfo per schema. However, the problem occurs only on the above scenario, i.e. parent sits in one schema & the child sits in another schema. When i have a transaction which inserts data in to both parent & child table, I am not able to apply the revision history. If i make it to insert this in its own schema the purpose defeat. Is is possible to point only one table in a schema to use Revinfo table sitting outside the schema.

This is a kind of urgent need. any help would be greatly appreciated.