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