Re: Cannot create temp tables

Nigel Booty wrote: > Not a corporate problem this but irritating nevertheless. I have SQL > 4.13.UDI running on SCO UNIX 3.2 and as the creator of a database, I'm > unable to execute the "CREATE TEMP TABLE table (table_id INTEGER); " > statement. The error I get is > > 261: Cannot create file for table (USER.table) > 1: Not owner> > As USER I get this even if I just create a dummy database. Since I have > a single user system, I have made sure that /tmp and all directories > where a temp table might be placed have 777 permissions and there is > planty of space. If su to informix, I can create the hich then exists in > /tmp. > > I can of course create normal tables. > > Can anyone throw light on what I need to do? > > I'd be grateful > > -- > Nigel Booty Hi Nigel, I also had a problem "Not Owner" and the access rigths on the directory were ok. It was not with creating a temp table but with set explain on. Maybe, the reason is the same. Here is what you should verify: Cehck the ownership and access rights of th Informix binaries (in $INFORMIXDIR/bin). Some of them shuold be root/informix and have a sticky bit set. The information about the correct owner/group and access rights can be found in a file called $INFORMIXDIR/etc/onlinefiles (or similar). Hope this helps Helmut Leininger Bull AG Unix Support Email: Helmut.Leininger@bull.net