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

"Michael Maier" <maier_michael2003 (AT) yahoo (DOT) de> wrote

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

"Mark C. Stock" <mcstockX@Xenquery .com> wrote

Here you are. ^_^

select owner, table_name
from dba_tables
where table_name not in
(select TABLE_NAME
from dba_constraints
where CONSTRAINT_TYPE='P')
and owner not in ('SYS', 'SYSTEM');

Hi,

thx a lot, i will try it tomorrow.


Best Regards,
Micha

maier_michael2003 (AT) yahoo (DOT) de (Michael Maier) wrote in message news:<99f00224.0409091212.336e2937 (AT) posting (DOT) google.com>...
-------------------------------------------------

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