Re: Which DES2K table contain Table and Column description

From: Jim Buckley - SY73049 <james.buckley_at_fmr.com>
Date: 1997/01/17
Message-ID: <32DFD659.7984_at_fmr.com>#1/1


Roger Snowden wrote:
>
> Use d2k to reverse engineer the repository.
>
> > Can someone tell me which DES2K repository tables contain table and
> > column description. Is there a published document talks about DES2K
> > repository tables?

To answer your question most directly, the name of the table where all descriptions are held is called:

CDI_TEXT The table contains all rows for descriptions for all repository elements. By querying this table for the specific type of text (such as 'CDIDSC' or 'CDINOT' for "descriptions" or "notes" respectively).

There are two means by which you can get much more complete information. 1st and most importantly, there is a file (an unload .DAT) file provided by Oracle. This file is distributed with D2K and can be loaded into the repository. The resulting application is a list of view and foreign-key definitions that represent the D2K structures.

This represents a complete design spec that I've used to drive report module definitions to create Oracle*Report modules that provide custom reports for our needs.

Drv:\OraWin95\Des2_60\Creq60\Model\

Mod_1_3.dat - an unloaded definition of the D2K model. Mod_1_3.dmp - an application export file of the D2K model.

Each file provides the dictionary definition you'd be looking for.

Hope this helps! Received on Fri Jan 17 1997 - 00:00:00 CET

Original text of this message