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