Re: Thanks, but... [2]

On Fri, 28 Jan 2005 18:33:52 +0100, "Piotr B." <piotrb_at_nie.spamuj.mnie> wrote:

>Unfortunately, my problem remains unsolved. I want to write some
>application to export database schema from Oracle, and I don't
>see an easy way to distinguish "real", user-added check constraints
>(like "GENDER IN ('M', 'F')") from automatically generated and
>redundant "column IS NOT NULL" constraints for every non-null column.

The constraints are not redundant.
Also the constraint name will always start with SYS_C You also shouldn't 'write some application' as Oracle comes with a export in any version
b dbms_metadata in 9i and higher

Looks like you would better concentrate on getting familiar with Oracle, than reinventing the wheel.

--
Sybrand Bakker, Senior Oracle DBA