Re: DBSPACETEMP problem

Hola Isidre, Yes, everything you described is normal behavior. If you want the temp table to be created in the DBSPACETEMP setting then you have to use the WITH NO LOG clause when creating explicit temporary tables with CREATE TEMP TABLE ... or SELECT ... INTO TEMP ... . Hope this helps, Hasta pronto, Cristian. Pons Roca, Isidre wrote: > > Hi all. > > Can any one help my? > > I've detectec de next problem (is'nt a heavy problem, but is very > tedious): > > When any user execute "create temp table a (a char(80))" the > temp table was create at rootdbs. (?') > > The Online system has defined a DBSPACE temp. > The user have defined de environment variable DBSPACETEMP, > pointting to a temp dbspace. > > The onconfig have defined the parameter DBSPACETEMP, > pointing to same dbspace defined by the environment variable. > > Is this the normal work method? > > I've detected other work metod: > If the temp table was generated by Online (for exemple needed > in a order by) the temp table has builded at DBSPACETEMP. > (more ?') > > What is wrong? > > Extra information: > Online version: 7.24.UC2-1 > OS version: Solaris 2.4 > > Thanks in advance. > (Sorry for my bad english) > > --------------------------------------- > Isidre PONS ROCA > Diputacio de Tarragona > Servei de Sistemes de Informacio > Ps Sant Antoni 100 > 43003 - Tarragona > SPAIN > Tel # +34 (9)77 296635 > Fax # +34 (9)77 196633 > http://www.altanet.org > ipons@dtgna.altanet.org > ---------------------------------------