Check if partitioning is enabled

This is a simple way to check if partitioning is enabled on a Oracle DB:

select decode(count(*), 0, 'No', 'Yes') Partitioning
from ( select 1
from dba_part_tables
where owner not in ('SYSMAN', 'SH', 'SYS', 'SYSTEM')
and rownum = 1 );