delete from table_name where rownum <4700000; -- (6 M -1.3 M) whatever

-----Original Message-----
From: Oracle DBA Help [mailto:[Email Address Removed] Tuesday, October 21, 2003 9:50 AM
To: LazyDBA.com Discussion
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