Alter table not logged Problem

Alter table not logged Problem

 

  

Hi,

I want to execute a DML statement which gives Not enough log space problem. I dont want to increase the log size. When I use "Alter table not logged initially", I am not able to retrive back the table info, if the DML operation fails. Is there any better way to do this. Pls help me.

Regards
Irshad.M
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

Visit us at http://www.cognizant.com
DB2 & UDB email list listserv db2-l LazyDBA home page