Re: select * from tab into temp with no log

CSC Employee wrote: > Helps please, > When I select join from tables tinto temp with no log, I ran into error > 229. I don't seem to have any problem if select from a single table, > even if with complicate criteria. > > There are plenty of space in temp dbspaces, and log dbscpces. > > Any suggestion what the problem might be? > > Thanks, > chariya together with 229 you'll probably get another error code. This onde should be useful... check the other answers given to you, and take this second error code into consideration. Maybe the server is trying to create some temporary file and you have no space left, or permissions... Regards.