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
> system generated constraints
rokyj055
post Jul 5 2012, 02:52 PM
Post #1


Advanced Member
***

Group: Members
Posts: 75
Joined: 23-January 12
Member No.: 46,637



Hi All ,


I was wondering with dba_constraints and i found unexpected result shown as below

select constraints_name, constraint_type from dba_constraints

constraint_name constraint_type
SYS_C00141 c
SYS_C00142 c
SYS_C00143 c
SYS_C00144 c
SYS_C00145 c
SYS_C00146 c
SYS_C00147 c
SYS_C00148 c
SYS_C00149 c


i jst want to know that what is this system generated constraints ?




Go to the top of the page
 
+Quote Post
burleson
post Jul 6 2012, 09:49 AM
Post #2


Advanced Member
***

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



Hi,

>> i jst want to know that what is this system generated constraints ?

Your query is not complete enough to show the full details, but they look like "check" constraints".

Run the script here:

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

Here is what a check constraints does:

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


--------------------
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
rokyj055
post Jul 13 2012, 06:01 AM
Post #3


Advanced Member
***

Group: Members
Posts: 75
Joined: 23-January 12
Member No.: 46,637



Dear Sir ,
Thanx for reply
you are right that these constraints are of "Check" constraints .

But i havent created them ,
then why these have been created ??


please reply ....

Go to the top of the page
 
+Quote Post
burleson
post Jul 13 2012, 09:39 AM
Post #4


Advanced Member
***

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



Hi,

>> why these have been created ??

They may be part of the Oracle data dictionary, you need to dig deeper to see!



1 - Query dba_constraints to get the table name

2 - Run dbms_metadata to get the table definition, and the check constraoints will appear. Here's how:


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


--------------------
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: 17th September 2014 - 08:30 AM