Mega Code Archive
Query dba_tables for table info
<![CDATA[
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> --
]]>