Find the Oracle Default Tablespaces

by Granville Bonyata on August 28, 2014

Short and to the point:
SELECT * FROM database_properties WHERE property_name LIKE 'DEFAULT%TABLESPACE';