Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deleting Duplicate Rows

Re: Deleting Duplicate Rows

From: Inna Zelmanova <izelmanova_at_yahoo.com>
Date: Sun, 17 Sep 2000 23:15:12 -0700 (PDT)
Message-Id: <10622.117223@fatcity.com>


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! Received on Mon Sep 18 2000 - 01:15:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US