Re: 7.23 doesn't use tempdbs
If the database has logging, you need to use the "with no log" clause
in your sql statement to cause the table to be created in the
DBSPACETEMP area.
J.
> > Hi,
> > =20
> > I have Online 7=2E23=2EUC6 running on AIX 4=2E2, with over 1/2 Gb avai=
> > lable=20
> > in my tempdbs=2E DBSPACETEMP is set to tempdbs in the onconfig file,=20
> > and is not set in my environment=2E However, any temp table created,=20
> > implicitly or explicitly, goes into my rootdbs, which has only 40Mb=20
> > free=2E Any ideas anyone?
> > =20
> > TIA
> > Davin
> >
> > **********************************************************************
> > DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu=
> > k=20
> >
>
> --
> Vic Goldberg
> Manager, DBA Team, Cornell University
> (607) 254-7441 (Voice) (607) 255-6982 (Fax)