列出用户分区表

select   distinct   table_name   from     user_tab_partitions;

select dt.table_name from dba_tables dt where dt.Partitioned = 'YES'
and dt.owner = 'USERNAME'