Re: Tables without primary key

From: Pablo R <pablo.rovedo_at_gmail.com>
Date: 10 Sep 2004 16:10:27 -0700
Message-ID: <b2dc1142.0409101510.23dc206b@posting.google.com>

maier_michael2003_at_yahoo.de (Michael Maier) wrote in message news:<99f00224.0409091212.336e2937_at_posting.google.com>...
> Hi,
>
> thx a lot, i will try it tomorrow.
>
>
> Best Regards,
> Micha

An easier and faster way to do it would be doing the following:

select owner,table_name from dba_tables
minus
select owner,table_name from dba_constraints where constraint_type != 'P'

Pablo Rovedo
from Argentina Received on Fri Sep 10 2004 - 18:10:27 CDT