Re: How to drop temp tables ....?

----- Original Message ----- To: fcaleya@briti.sh At: 2/ 5 14:13 Temp tables are normally deleted when the users' sessions end. There are certain conditions which can leave them around so the engine cleans them all up at startup time. So...bounce the engine and they will disappear (assuming you do not have one of the older versions with a bug in that code). Art S. Kagel ----- Original Message ----- From: Fatima Caleya <fcaleya@briti.sh> At: 2/ 5 14:11 > Hi everybody! > > I hope you can help me on this. > > We have several applications which leave temp tables on the rootdbs and need to > > drop them . > > Is there a way to do that, even when the owner is gone? > > Thanks for your help in advance. > > Fatima. > > -- Fatima Caleya > -- IBM Consultant > -- fcaleya@briti.sh > > > > <br><br><br><a href="http://www.universalpostoffice.com"><img > src="http://www.universalpostoffice.com/mail/imgs/upo-small.gif"; width="76" > height="55"></a>