From: mcstockX@Xenquery   
      
   "Michael Maier"  wrote in message   
   news:99f00224.0409080001.2142293e@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)