Everything you need to know about constraints is in dba_constraints and
dba_cons_columns. Take a look at how these work by examining some existing
constraints. Then make a few constraints, edisable/enable them, to see what
gets created. Very interesting.
- Dan Clamage
--
T'was Brillig,
And the slithy toves
Did gyre and gimbol in the wabe;
All mimsey were the borogroves,
And the mome raths outgrabe.
- Lewis Carroll
Matteo De Rosa <email_at_domain.com> wrote in article
<356AE17A.8250E571_at_domain.com>...
> hello everyone...
>
> We have Oracle 7.3.2.2.0 on AlphaServer 2000 4/200 / Digital UNIX 4.x
> and
> Oracle Server Manager 2.3.2.0.0. on PC/Windows95.
>
> As dba i need know all constraint of, for examples, USER1 user on
> TABLE1 table;
> for each one i need know what constraints is it and what attribute is
> implicated.
>
> Oracle Server Manager 2.3.2.0.0. on PC/Windows95 don't seem have this
> capability;
> can i create a specific view on server side ? And which ?
>
> Whichever hint is appreciated.
>
>
>
> thank you all...
> Matteo DE ROSA
> derosa_at_epoca1.portici.enea.it
>
>
>
>
Received on Wed May 27 1998 - 19:33:13 CDT
