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 -> help: what is the difference between "xx" and xx

help: what is the difference between "xx" and xx

From: Joe Sath <dbadba62_at_hotmail.com>
Date: Wed, 17 Apr 2002 00:42:26 GMT
Message-ID: <Sx3v8.35112$8W5.32403@nwrddc02.gnilink.net> 





I have a constraint, when I search against the dba_constraints, it shows up
as cons_fk_a,


but when I use alter table bla drop constraint cons_fk_a, I got an error
that nonexistent,


I have to use



alter table bla drop constraint "cons_fk_a".



While some other constraints do not have the problem.



why?



Thanks for your help.
Received on Tue Apr 16 2002 - 19:42:26 CDT












Original text of this message













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