Re: Temp table
Colin Bull wrote:
> I usually use-
>
> drop table TEMPNAME ;
What, without a session? :-)
>>-----Original Message-----
>>From: owner-informix-list@iiug.org
>>[mailto:owner-informix-list@iiug.org]On Behalf Of Vaclav.Boura@cpp.cz
>>Sent: 21 May 2003 07:44
>>To: informix-list@iiug.org
>>Subject: Temp table
>>
>>
>>Hello all,
>>how can I drop temp table in my rootdbs which is without
>>active session?
The temp tables should be cleared up next time you start-up (don't use
-p option) your database server. If not, then ring tech support.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+