Short and to the point:
SELECT *
FROM database_properties
WHERE property_name LIKE 'DEFAULT%TABLESPACE';
Find the Oracle Default Tablespaces
Previous post: Find size of LOB securefiles
Next post: Dynamically set the name of the spool file
Previous post: Find size of LOB securefiles
Next post: Dynamically set the name of the spool file