Re: ci_ views

"Iain Brown" <iain.brown_at_uk.thalesgroup.com> wrote i

> 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

Me: "Lovely weather we've been having."

Then you go "What's this about the weather".

I respond "Exactly".

And you go "Huh?".

And I go "Exactly."

In case you still don't get it - take a look at the Oracle Reference Manual, Section 2, Static Data Dictionary Views. (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/toc.htm)

--
Billy