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_at_posting.google.com>
Date: 10 Sep 2004 16:10:27 -0700
Message-ID: <b2dc1142.0409101510.23dc206b_at_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 Sat Sep 11 2004 - 01:10:27 CEST