rychlovka – data dictionaries
Dolezite data dictionaries/catalog views pouziva asi kazdy priblizne rovnake:
_OBJECTS
_CATALOG
_DICTIONARY
_USERS
_TABLES
_VIEWS
_SYNONYMS
_TRIGGERS
_INDEXES
V$DATABASE
V$PARAMETER
V$INSTANCE
V$SESSION
V$SYSTEM_PARAMETER
atd…
…. ale co robit, ked potrebujem nejaky specificky dictionary (typicky priklad – privilegia, viem, ze by to malo mat _PRIVS, ale presny nazov si nepamatam). Idealne selectovat z katalogu data dictionaries (kolegom vtipne oznaceny ako “katalog katalogov”).
SQL> desc DBA_CATALOG
SQL> select OWNER, TABLE_NAME from dba_catalog where OWNER = ‘PUBLIC’ and TABLE_NAME like ‘%PRIVS%’;
Ten PUBLIC OWNER je pekny, pretoze vyselektuje len tie, ktore maju public synonyma nie celu zaplavu tabuliek pod DBA_