Transactions & Cluster groups
Posted by:
Ira Kam
Date: February 11, 2006 04:59AM
Can a single transaction span across data found in different data partitions being managed by different cluster groups?
If so what is the mechanism?
Example:
I have 1 table called 'Product_catalogue' that stores all the products catalogue of a large company. In addition I have another table called 'Product_mapping' that maps external product names (of partners) to internal product names.
Both table are quite large and or partitioned across 2 cluster groups managing a different set of partitions.
Per each transaction: (1) A lookup is performed between the 'external' product name to the 'internal' product name. (2) Then several updates are performed on the Product catalouge table and joined tables, joined by the internal product name.
Subject
Views
Written By
Posted
Transactions & Cluster groups
2045
February 11, 2006 04:59AM
1344
February 12, 2006 02:42AM
1295
February 16, 2006 12:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.