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

Home -> Community -> Usenet -> c.d.o.server -> help:delete duplicated records

help:delete duplicated records

From: sc <cfs3526_at_hotmail.com>
Date: Mon, 9 Oct 2000 14:22:01 -0400
Message-ID: <971115726.509012@newsreader-hpw1.net.bms.com> 






I have a table which has about 20,000 duplicated rows.  When I was trying to
delete it using rowid, it takes for ever to finish, finally I have to cancel
the query.  Could somebody tell me how I should do with it?  I can not
enable PK now for the table.



Thank  you for you help.
Received on Mon Oct 09 2000 - 13:22:01 CDT












Original text of this message













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