Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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
Jacodia
post Sep 3 2017, 03:51 PM
Post #1


Newbie
*

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



Hi
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:
http://docs.oracle.com/cd/E25054_01/server...ma.htm#autoId12

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
burleson
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:

http://www.dba-oracle.com/t_dba_constraints.htm

I have other notes on check constraints here:

http://www.dba-oracle.com/t_oracle_check_constraint.htm

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