View Single Post

   
  #6 (permalink)  
Old 02-27-2008, 04:46 AM
Thiru
 
Posts: n/a
Default Re: Transaction log full

I insist, the following idea is not good.This may lead to loss of data.
Try at ur own risk.

Disable logging for the particular table and perform load operation or
delete or what ever.

Make sure to QUIESCE the table/tablespace. So that so user will not be
allowed to access until UNQUIESCE is issued.

Thiru
WantedToBeDBA.

Reply With Quote