Home » RDBMS Server » Server Administration » subpartition template view (11.1.0.7 windows xp)
subpartition template view [message #526676] Wed, 12 October 2011 07:07 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
Are there some oracle views about subpartition template?
Re: subpartition template view [message #526677 is a reply to message #526676] Wed, 12 October 2011 07:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
10 seconds to find:
SQL> desc DBA_SUBPARTITION_TEMPLATES
 Name                                 
 -------------------------------------
 USER_NAME                            
 TABLE_NAME                           
 SUBPARTITION_NAME                    
 SUBPARTITION_POSITION                
 TABLESPACE_NAME                      
 HIGH_BOUND                           

Regards
Michel
Re: subpartition template view [message #526679 is a reply to message #526677] Wed, 12 October 2011 07:39 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sometimes it helps if you query DICTIONARY. If you didn't do that yet, take a look - LIKE can do magic (in both TABLE_NAME and COMMENTS).

Here's an example:
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>
Re: subpartition template view [message #526682 is a reply to message #526679] Wed, 12 October 2011 07:53 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks a lot!
Previous Topic: listener could not hand off client connection
Next Topic: iSQL*Plus login for DBA
Goto Forum:
  


Current Time: Tue Sep 30 13:02:18 CDT 2014

Total time taken to generate the page: 0.13200 seconds