Oracle Database 12cR2 new feature: Container Maps

May 24, 2017 8:31:00 AM by Deiby Gomez


This is a companion discussion topic for the original entry at https://blog.toadworld.com/2017/05/24/oracle-database-12cr2-new-feature-container-maps

Hi,

Thank you for explaining the concept.Its very useful.

I have a situation. I created a container map and enabled tables to use Container Map using the instructions shared in this blog. But when i try to query view built on the tables which container map aware return duplicate rows.

i,e Query from App Root returns double the number of rows when compared to querying from App PDB.

Is this expected behaviour? Does this mean we cant query VIEWS from APP ROOT?

Thanks and Regards,
Mastan Ali.