Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Data Dictionary - Primary Keys

Re: Data Dictionary - Primary Keys

From: Ulrich F. Zeh <zeh_at_regware.de>
Date: Tue, 22 Dec 1998 08:31:11 +0100
Message-ID: <367F4ABE.3FA26C2F@regware.de> 





You are right Jim, I forgot to filter the constraint type.
For using the DBA_-dictionary tables the user must have dba grants!



Jim Lyons wrote:



> Ulrich F. Zeh wrote:


> >


> > hi Craig,


> > if the tables are your's use USER_CONS_COLUMNS otherwise use


> > ALL_CONS_COLUMNS



> >





Received on Tue Dec 22 1998 - 01:31:11 CST












Original text of this message













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