Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g - Putting a where clause on a column with a check constraint.

Re: Oracle 10g - Putting a where clause on a column with a check constraint.

From: Jon <jonathan.p.crawford_at_gmail.com>
Date: 22 Mar 2006 13:36:14 -0800
Message-ID: <1143063374.731569.189300@t31g2000cwb.googlegroups.com>

More Information...

If I make the constraint NOVALIDATA or if I disable the constraint, the queries work as expected. This is a huge stumbling block to our integration with 10g. Received on Wed Mar 22 2006 - 15:36:14 CST

This message: [ Message body ]
Next message: Chuck: "Re: Database Restore"
Previous message: Alien: "Re: create table as select with different execution plan"
In reply to: Jon: "Oracle 10g - Putting a where clause on a column with a check constraint."
Next in thread: DA Morgan: "Re: Oracle 10g - Putting a where clause on a column with a check constraint."
Reply: DA Morgan: "Re: Oracle 10g - Putting a where clause on a column with a check constraint."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US