USER_ALL_TABLES

obclient [SYS]> SELECT TABLE_NAME, STATUS, PCT_FREE, NUM_ROWS, PARTITIONED, TEMPORARY, ROW_MOVEMENT, DROPPED, EXTERNAL FROM SYS.USER_ALL_TABLES WHERE TABLE_NAME='T_SUBPART';

+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
| TABLE_NAME | STATUS | PCT_FREE | NUM_ROWS | PARTITIONED | TEMPORARY | ROW_MOVEMENT | DROPPED | EXTERNAL |
+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
| T_SUBPART  | VALID  |        0 |     1000 | YES         | N         | NO           | NO      | NO       |
+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
1 row in set