db.dobo.sk

rychlovka – data dictionaries

bez komentára

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_

 

 

píše: ďobo

Jún 5th, 2015 o 4:50 am

chlievik: oracle

okomentuj