FAQ
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).

Search Discussions

  • Hatzistavrou Giannis at May 17, 2001 at 12:17 pm
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 17, '01 at 1:09a
activeMay 17, '01 at 12:17p
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase