|
-
Hi guys,
What is the meaning of following Constraint types which I saw in dba_constraints
C
O
P
R
U
V
I think all know about C, P, R and U but what about O and V?
Secondly, what is the exact use of perfmon utility of NT and how can I use it for performance monitoring of Oracle Database. I have never found it very useful and much enjoying.
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Here is the explanation:
C (check constraint on a table)
P (primary key)
U (unique key)
R (referential integrity)
V (with check option, on a view)
O (with read only, on a view)
Sam
Thanx
Sam
Life is a journey, not a destination!
-
good question
Type of constraint definition:
C (check constraint on a table)
P (primary key)
U (unique key)
R (referential integrity)
V (with check option on a view)
O (with read only, on a view)
- Magnus
-
Thanks Sambavan,
if someone could answer the perfmon part plz...
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|