Query dba_tables for table info : DBA_Tables « System Tables Views « Oracle PL / SQL





Query dba_tables for table info

  
SQL>
SQL> set verify off
SQL> set linesize 76
SQL> set pagesize 9999
SQL>
SQL> break on tablespace_name skip 1
SQL> column tablespace_name  format a15
SQL> column table_name       format a30
SQL> column table_properties format a30 word_wrapped
SQL>
SQL> select tablespace_name, table_name,
  2         decode( partitioned, 'YES', 'Partitioned ',
  3           decode( logging, 'NOLOGGING', 'Non-logging table ' ) ) ||
  4         decode( temporary, 'Y', 'Temporary (' ||
  5                 decode( duration, 'SYS$SESSION', 'Session-based',
  6                                                  'Transaction-based' ) ||
  7                 ')',
  8         '' ) ||
  9         decode( iot_type, null, '', 'Index-organized ' ) ||
 10         decode( nested, 'YES', 'Nested ', '' )
 11         table_properties
 12    from dba_tables
 13   where rownum < 50
 14  /
Tablespace Name Table Name
--------------- ------------------------------
TABLE_PROPERTIES
------------------------------
SYSTEM          ICOL$


                CON$


                UNDO$


                PROXY_ROLE_DATA$


                FILE$


                UET$


                IND$


                SEG$


                COL$


                CLU$


                PROXY_DATA$


                TS$


                BOOTSTRAP$


                FET$


                CCOL$


                USER$


                OBJ$


                TAB$


                CDEF$


                OBJAUTH$


                UGROUP$


                TSQ$


                SYN$


                VIEW$


                TYPED_VIEW$


                SUPEROBJ$


                SEQ$


                PROCEDURE$


                PROCEDUREINFO$


                ARGUMENT$


                SOURCE$


                IDL_UB1$


                IDL_CHAR$


                IDL_UB2$


                IDL_SB4$


                DIR$


                JAVAOBJ$


                ERROR$


                SETTINGS$


                TRIGGER$


                TRIGGERCOL$


                TRIGGERJAVAF$


                TRIGGERJAVAS$


                TRIGGERJAVAC$


                TRIGGERJAVAM$


                SYSAUTH$


                OBJPRIV$


                DEFROLE$


                PROFILE$




49 rows selected.

SQL>
SQL> --

   
  










Related examples in the same category

1.Get owner, table name and table space name from dba_tables
2.Data Dictionary Scope
3.Query dba_tables by owners
4.select cluster_name, owner, table_name from dba_tables