Niels Lippke wrote:
>
> Hi,
>
> I need to find these rows in my table, that
> appear more than one time. But I don´t know how
> to construct a SQL-Query that returns
> these rows.
>
run the script UTLEXCPT.SQL to create an exceptions
table under your schema.
Then run something like...
ALTER TABLE foo
ADD CONSTRAINT u_foo
UNIQUE (cola, colb)
USING INDEX
TABLESPACE ts_name
EXCEPTIONS INTO myschema.exceptions
;
--
*------------------------------*----------------------------*
| Andrew Allen | Against fools, the gods |
| Process Leadership / PSL DBA | themselves contend in vain |
| Dearborn, MI USA | -- author unknown |
*------------------------------*----------------------------*
Received on Tue Feb 29 2000 - 00:00:00 CST
