partition

SELECT table_name, partitioned
FROM user_tables
WHERE table_name = 'ZORDERDETAIL';

SELECT table_name, partitioning_type, subpartitioning_type, partition_count
FROM user_part_tables
WHERE table_name = 'ZORDERDETAIL';

SELECT partition_name, high_value, tablespace_name, num_rows
FROM user_tab_partitions
WHERE table_name = 'ZORDERDETAIL'
ORDER BY partition_position;

SET LONG 10000
SELECT DBMS_METADATA.GET_DDL('TABLE','ZORDERDETAIL') FROM DUAL;