SQL> desc DBA_SUBPARTITION_TEMPLATES
 Name                                 
 -------------------------------------
 USER_NAME                            
 TABLE_NAME                           
 SUBPARTITION_NAME                    
 SUBPARTITION_POSITION                
 TABLESPACE_NAME                      
 HIGH_BOUND                           

SQL> show user
USER is "SCOTT"
SQL> select table_name from dictionary where table_name like '%SUBPAR%TEMPL%';

TABLE_NAME
------------------------------
USER_SUBPARTITION_TEMPLATES
ALL_SUBPARTITION_TEMPLATES

SQL>

SQL> col comments format a60
SQL>
SQL> select table_name, comments from dictionary
  2  where upper(comments) like '%WORKSPACE%';

TABLE_NAME                     COMMENTS
------------------------------ ------------------------------------------------------------
USER_AW_PROP                   Object properties in Analytic Workspaces owned by the user
ALL_AW_PROP                    Object properties in Analytic Workspaces accessible to the u
                               ser

USER_AW_OBJ                    Objects in Analytic Workspaces owned by the user
ALL_AW_OBJ                     Objects in Analytic Workspaces accessible to the user
ALL_AW_PROP_NAME               Analytic Workspace property names accessible to the user
ALL_AW_AC                      Active Catalog Analytic Workspaces accessible to the user
ALL_AW_NUMBERS                 Analytic Workspace numbers accessible to the user
USER_AWS                       Analytic Workspaces owned by the user
ALL_AWS                        Analytic Workspaces accessible to the user
USER_AW_PS                     Pagespaces in Analytic Workspaces owned by the user
ALL_AW_PS                      Pagespaces in Analytic Workspaces accessible to the user

11 rows selected.

SQL>