home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,726 of 2,288   
   .com to Michael Maier   
   Re: Tables without primary key   
   08 Sep 04 05:51:15   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca