Re: Tables without primary key

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 8 Sep 2004 05:51:15 -0400
Message-ID: <9MydnRI6YN6LS6PcRVn-uw@comcast.com>

"Michael Maier" <maier_michael2003_at_yahoo.de> wrote in message news:99f00224.0409080001.2142293e_at_posting.google.com...
| Hi,
|
| for an OnlinerReorg (SAP/ORACLE) i have to know the name of the tables
| without primary key.
|
| Where can i find it with sqlplus or abap?
|
| THX
|
| Best Regards,
| Micha

assuming SAP uses database constraints, these are all listed in the DBA_CONSTRAINTS (or USER_CONSTRAINTS) data dictionary view, CONSTRAINT_TYPE = 'P'

you can write a query outer joining this to DBA_TABLES (or USER_TABLES) and check for NULL constraint names, or use a MINUS type query

are you familiar with these techniques?

++ mcs Received on Wed Sep 08 2004 - 04:51:15 CDT