I have a process which needs to be run each night and essentially consists of deleting a number of tables and then repopulating them based on an number of XML files.
I found that unless I set the log_mode to demo, I end up filling up my log device. I sometimes get the same problem if I execute a query with a lot of outer joins. I would like to be able to change the log mode to demo just before I execute this process and then revert to single or dual after this process executes. Can I accomplish this via SQL or do I need to use dbmcli and if so what is the relevant command I need to use ? Is there any other way of preventing the log device from being filled ? Cheers -Mohamed _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
