Products | Versions |
---|---|
TIBCO Adapter for Oracle Applications | - |
Not Applicable | - |
Resolution:
The publication table can be created in a schema different from the source table schema. The adapter generated SQL script creates publication table in user schema which might be different than the schema the source table resides in.
But the MV Log cannot be created under a different schema from their master table, the main table for the business object selected. This is an Oracle restriction
Please refer Oracle Documentation for Oracle 10g, for complete details on the Materialized View Logs:-
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#CNCPT010