Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> ORacle 10g Enterprise Manager, Creating Check Constraints
post Sep 3 2017, 03:51 PM
Post #1


Group: Possible Spammers
Posts: 1
Joined: 3-September 17
Member No.: 52,143

REally hope someone will be able to help before tomorrow's test :-)

I need to create a CHECK constraint using Enterprise Manager.

The constraint creates successfully, but does not display the Column on the constraint:

I have done exactly this:

Thank You
Attached File  Untitled.png ( 83.62K ) Number of downloads: 0

Attached File  233.png ( 174.18K ) Number of downloads: 0
Go to the top of the page
+Quote Post
post Sep 4 2017, 07:00 AM
Post #2

Advanced Member

Group: Members
Posts: 13,532
Joined: 26-January 04
Member No.: 13

Hi Jacodia, and welcome to the forum!

This is why I don't trust OEM!

Instead, just query dba_constraints in sql*plus:


I have other notes on check constraints here:


Good luck!

Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 23rd September 2017 - 10:14 PM