List all tables that have partitions

select owner,table_name 
from all_tables 
where PARTITIONED = 'YES' and not owner in ('SYS','SYSTEM') 
order by owner, table_name

	OWNER	TABLE_NAME
1	IDM_OWNER	D_GROWTH_FACTOR
2	IDM_OWNER	F_ASN
3	DMITRI	TEST