find partition name of table code example Example: how to see all table partition in oracle SELECT * FROM ALL_TAB_PARTITIONS;