Re: Deleting all rows from a Table

Hi Greg,

if you want to delete all rows issue a truncate <table>. (Only in 7.x)

Another way is this:

delete from table <table> where rownum < 1000;

commit;

again until all are deleted.

I hope this helps,

Toni

+--------------------------------------------------------------------+


| Anton Dischner, DBA and system-programmer    Phone: +49 89 70953202|

| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|

| Klinikum Grosshadern                         Home : +49 89 6254060 |

| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|

| 81366 Muenchen                                                     |

| Marchioninistr. 15                                                 |


| Germany                          Mail: dischner_at_med.uni-muenchen.de|


 +--------------------------------------------------------------------+