delete from table where rownum <1300000


----- Original Message -----
From: Oracle DBA Help
To: LazyDBA.com Discussion
Sent: Tuesday, October 21, 2003 3:49 PM
Subject: delete records until I have about 1.3 million records.


How can I delete records from a table until I have about 1.3 million records. Doesn't matter what the records are, just need about that many in a table. There's about 6 million in there now. And unfortunately there's now way to group or sort out data that could equal to amount of 1.3 million.

Any help appreciated here,



Pseudo of what I need



Delete from table

Where count(1) > 1,300,000.




Oracle LazyDBA home page