Help - Search - Members - Calendar
Full Version: system generated constraints
Oracle DBA Forums > Oracle > Oracle Forum
rokyj055
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 ?




burleson
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
rokyj055
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 ....

burleson
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.