RE: Deleting Duplicate Rows

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Mon, 18 Sep 2000 11:13:56 +0400
Message-Id: <10623.117225@fatcity.com>

Hi,
The suggestion given bin Inna is a good work around, but is not feasible in real life situation. Imagine the table is used for online transaction and you have huge amount of data present in it.

Khan, out of curiosity, do you have any particular reason why you don't want to use the rowid for duplicacy check.

Thanks,
Amar
00-971-50-7883254
ts2017_at_emirates.com
amar_padhi_at_hotmail.com
amar_padhi_at_musclemail.com

-----Original Message-----
From: Inna Zelmanova [mailto:izelmanova_at_yahoo.com] Sent: Monday, September 18, 2000 11:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: Deleting Duplicate Rows

Hi,if for some reasons you don't want to use rowid, try this:
step 1.
create table table_name2
as select distinct * from table_name1;
step 2.
drop table_name1;
step 3.
rename table_name2 to table_name1;
step 4.
Don't forget to recreate any
constraints,indexes,triggers and permissions that were on the original table.

inna

Method
--- Azizulah Khan <Azizulah.Khan_at_almarai.com> wrote:
>
>
>
> Hi list,
>
> Do anyone have idea of deleting duplicate rows
> without using ROWID from the
> table ????.
>
> TIA
>
> Khan
>
> --
> Author: Azizulah Khan
> INET: Azizulah.Khan_at_almarai.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).

---

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

-- 
Author: Inna Zelmanova
  INET: izelmanova_at_yahoo.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

Received on Mon Sep 18 2000 - 02:13:56 CDT