I have a client that is looking migrate from a DB2 environment over to Oracle 11.2.0.x database and during the design this question is coming up to see if this is feesiable to pursue as a technogy. Along with using IOT's, the client is also wanting to replicate data via Golden Gate 12.1.x.
We are having to partition & cluster our table(s) in oracle as our tables house large data and we have the need to
cluster to perform efficient retrieval. But we found out that we cannot have
both partition & cluster on a normal table and partition / cluster are
mutually exclusive.
It looks like Index Organized Table would allow me to cluster my
table on the primary key and would also allow me to partition.
Our requirements are
Achieving clustering based on the primary key
- Achieve partitioning
- Achieve active – active data replication through golden gate to
another data center - Have data columns as part of IOT
- Need to have the ability to define secondary indexes for
retrieval of data apart from primary key itself
Are there any issues and/or drawbacks in using IOT's with large amounts of data/inserts?