Re: dba_cons_columns table is messed up

A copy of this was sent to kal121_at_my-deja.com (if that email address didn't require changing) On Wed, 23 Feb 2000 18:13:48 GMT, you wrote:

>Anyone seen this strange behavior before? I'm getting back double
>entries for the column names. I do not have this problem when I query
>user_cons_columns.
>
>
>> select column_name, constraint_name from dba_cons_columns where
>table_name = 'LOGIN' order by constraint_name;
>

you have the table LOGIN installed 2 times in your database. try:

select OWNER, column_name, constraint_name from dba_cons_columns where table_nam = 'LOGIN'
order by OWNER, constraint_name;

>COLUMN_NAME CONSTRAINT_NAME
>----------------- ------------------------------
>CONTACT_ID FK_LOGIN_CONTACT
>CONTACT_ID FK_LOGIN_CONTACT
>LOGIN_ID PK_LOGIN
>LOGIN_ID PK_LOGIN
>LOGIN_ID SYS_C001078
>CONTACT_ID SYS_C001079
>USERNAME SYS_C001080
>PASSWORD SYS_C001081
>PASSWORD_HINT SYS_C001082
>CREATED_BY_LOGIN SYS_C001083
>CREATED_BY_ROLE SYS_C001084
>DATE_CREATED SYS_C001085
>LAST_LOGIN SYS_C001086
>STATUS SYS_C001087
>LOGIN_ID SYS_C00962
>CONTACT_ID SYS_C00963
>USERNAME SYS_C00964
>PASSWORD SYS_C00965
>PASSWORD_HINT SYS_C00966
>CREATED_BY_LOGIN SYS_C00967
>CREATED_BY_ROLE SYS_C00968
>DATE_CREATED SYS_C00969
>LAST_LOGIN SYS_C00970
>STATUS SYS_C00971
>USERNAME UQ_LOGIN
>USERNAME UQ_LOGIN
>
>26 rows selected.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Feb 23 2000 - 13:30:28 CST