Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ci_ views

Re: ci_ views

From: andrewst <member14183_at_dbforums.com>
Date: Thu, 28 Aug 2003 06:40:18 -0400
Message-ID: <3294810.1062067218@dbforums.com>

Originally posted by Iain Brown

> Hi,

>

> I've been given the lovely task of documenting the contents of my
> project's

> database tables.

>

> I got told to use report generator with the ci_ views, e.g.

> ci_table_definition, ci_primary_key_constraints... etc.

>

> Anyway, I managed to get what I needed for the table itself, but
> for the key

> constraints, I cannot find how the ci_ views link the keys to
> their fields.

> E.g. a primary key called 'MME_PRK' was made up of 3 fields. Yet the

> ci_primary_key_constraints view contained 10 records with the name
> MME_PRK',

> all identical except the IVID and PARENT_IVID fields - which are
> the version

> id's. I didn't find anything obvious in the ci_columns view either.

>

> I'm using Oracle 9i

>

> Hope you can help,

>

> Iain

These CI_ views are part of Oracle Designer, they are not part of the Oracle server's data dictionary. I am not familiar with the latest version of Designer, but I know it has a new versioning system of some sort. Anyway, a primary key constrant will only have 1 (current) record in ci_primary_key_constraints, and the 3 columns that comprise the key will be found in ci_key_components (again, many times presumably, if there have been several versions).

--
Posted via http://dbforums.com
Received on Thu Aug 28 2003 - 05:40:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US