SQL> select * from DBA_CONS_COLUMNS where owner='XXXX' ;

SQL> select * from DBA_CONSTRAINTS where owner='YYYY' ;



[Edited by sreddy on 01-10-2001 at 02:32 PM]