Re: newbie question about data dictionary and views

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 13 Apr 2003 13:35:34 GMT
Message-ID: <b7bp36$csdkj$1@ID-82536.news.dfncis.de>

> kent wrote:

>> I am a newbie to oracle database, i just can't remember the name of the data
>> dictionary and views and their corresponding columns, so i can't rember
>> their functions, is there any general rules for naming the dictionary and
>> views?
>>
>>

> 
> All DBA_, USR_ and ALL_ views are plural, e.g. DBA_TABLES.
> All v$ stuff is not: e.g. v$datafile
> That's all I know about "rules".

There is no rule without an exception:

V$ARCHIVE_PROCESSES, V$BUFFER_POOL_STATISTICS, V$ACTIVE_INSTANCES, V$DLM_ALL_LOCKS, V$DLM_LOCKS, V$NLS_PARAMETERS, V$TIMEZONE_NAMES and

DBA_REPAUDIT_COLUMN, DBA_AUDIT_STATEMENT, DBA_REPRESOLUTION, DBA_REGISTRY to name but a few.

Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html

Received on Sun Apr 13 2003 - 08:35:34 CDT