Hi
Part 2:
you have to run the script utlexcpt.sql to create the exception table and
then issue
alter table table enable primary key exceptions into exceptions;
This will give you the rowids for the violating rows.
Jack
Rusnak, George A. [EMAIL PROTECTED]@fatcity.com on 07-09-2001
you can find the duplicate records which vilate primary key with this sql
select count(*) from table name
group by
DODAAC,
NSN,
CONTRACT
having
count(*)1
Shahid Malik.
-Original Message-
Sent: Friday, September 07, 2001 5:41 PM
To: Multiple recipients of list ORACLE-L
Good
I have not done it but you should be able to capture records into an
exception table.
1. Create exception table
create table exceptions(row_id rowid,
owner varchar2(30),
table_name varchar2(30),
constraint
George,
Here is one way:
select distinct a.DODAAC,b.NSN,c.CONTRACT count(*)
from tablea a, tableb b, tablec c
where (whatever your where clause is)
group by a.DODAAC,b.NSN,c.CONTRACT
having count(*) 1
This will give you the PK values of those records from your select where you
are producing
Hi
One way would be to do
select dodaac, msn, contract, count(*)
from table
group by dodaac, msn,contract
having count(*) 1
There is also a feature in Oracle that will send all the bad records to an
exception table if it violates a constraint but you'll have to read the
fine manual to find
