Hello Michael, can you verify whether the log of your database is full/becomes full during your operation?. If so, you should increase the log space. Whether or or not the command is sent with auto-commit does not affect the usage of the log space *during the command is running*, autocommit will only release some space *after the command did run*.
Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Michael MacIntyre [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 17, 2003 4:12 AM > To: [EMAIL PROTECTED] > Subject: Delete statement - SQL Studio > > > Hello, > I have a table I recently populated with data - via jdbc from another > datasource (it seemed easier than using repmcli). The > problem seems to > be when I wish to delete all of the rows. I issue the simple command > delete from table (wishing to discard all of the rows I inserted). I > let it run for about 4 hrs, with still no result. I thought > pehaps some > of the rows may have been locked (although I can delete a single row > without a problem), so I took it off line then back on again with > dbManager. No luck. Now I am trying to delete via jdbc, bu tthe end > result seems to be the same - this time I set AutoCommit() to TRUE. > There are only 5500 rows in the table... > any ideas? > Thank you in advance. > Michael MacIntyre > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
