RE: dba_contraints.table_name

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 23 Aug 2000 13:14:22 -0300
Message-Id: <10598.115396@fatcity.com>

With Check Option.

There are two constraint types that show up in dba_constraints that = have
nothing to do with tables:

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)=20

V and O are for views.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Lyall Barbour [SMTP:lbarbour_at_stanford.edu]
	Sent:	Wednesday, August 23, 2000 1:48 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: dba_contraints.table_name

	How can you have a constraint on a view?
	That sounds weird to me.  Is it possible?  Anyone?

	Lyall Barbour
	At 07:22 AM 8/23/00 -0800, you wrote:


	>Fyi, and probably you all know this already but I didn't,

	>

	>Dba_constraints has a column named table_name.

	>

	>That column doesn't just include tables, it includes views as well.

	>

	>Regards,

	>Patrice Boivin

	>Systems Analyst (Oracle Certified DBA)

	>

	>Systems Admin & Operations | Admin. et Exploit. des syst=E8mes

	>Technology Services        | Services technologiques

	>Informatics Branch         | Direction de l'informatique

	>Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

	>

	>--

	>Author: Boivin, Patrice J

	>   INET: BoivinP_at_mar.dfo-mpo.gc.ca

	>

	>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

	>San Diego, California        -- Public Internet access / Mailing

Lists
=09

>--------------------------------------------------------------------


	>To REMOVE yourself from this mailing list, send an E-Mail message

	>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

	>the message BODY, include a line containing: UNSUB ORACLE-L

	>(or the name of mailing list you want to be removed from).  You may

	>also send the HELP command for other information (like

subscribing).

	--=20
	Author: Lyall Barbour
	  INET: lbarbour_at_stanford.edu

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may

Received on Wed Aug 23 2000 - 11:14:22 CDT