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