Friends,
DB: 11gR2
OS: Linux
I have some questions/doubts regarding Oracle partitioning, would love to get responses from the professionals.
1. How do we know if partitioned table is range partitioning or interval range partitioning? (dba_part_tables?)
My understanding is range partitioned table will not add future partitions by itself and interval range partitioned will do, how to differentiate between them via query?
I can certainly extract table ddl to verify if it's interval or not but there should be definitely better way than that.
2. How can we list all parent and respective child tables of reference partitioned tables in the single query?
I can query dba_constraints, dba_part_tables and manually figure out parent tables by joining them but trying to write a single query to list both parent and child tables?
I did go through metalink to find details but couldn't find them, happy to also receive any metalink doc ID.
Thanks and appreciate your inputs.