RE: Script to remove redundant rows in a table?

there is also the case of trying to enable a unique constraint on the underlying table using the exeption option and creating an exception table(utlexcpt.sql). The unique constraint will of caurse fail but inside the exeption table the duplicate rowids will be written . Using this input you can delete from table the duplicates.

> -----Original Message-----
> From: Haskins, Ed [SMTP:Ed.Haskins_at_VerizonWireless.com]
> Sent: Thursday, May 17, 2001 04:10
> To: Multiple recipients of list ORACLE-L
> Subject: Script to remove redundant rows in a table?
>
> A few months ago I remember seeing a script that enabled the removal of
> redundant rows in a table. Can someone please forward or point me to such
> a
> script.
>
> I have an Oracle Names server that stores the database connect descriptors
> in a table within the Region Database. I've loaded these connect
> descriptors
> from many SQLNET.ora files throughout the enterprise. My problem is that
> there exists duplicates from the multiple SQLNET.ora files. I really want
> to
> clean this up so that only one entry per connect descriptor exists. I
> think
> that a generic script for any table will work in this situation.
>
> Thanks,
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Haskins, Ed
> INET: Ed.Haskins_at_VerizonWireless.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hatzistavrou Giannis
  INET: j.hatzistavrou_at_telesoft.gr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).