Re: moving tables

Quoting J. David Schronce... } } On our Altos 2000 machine the drive which contains my database is } almost full. I would like to move some of the larger data files to } another drive. I've noticed that systables contains the path for each } of the tables, but it won't let me edit the path (or anything else). } } I've logged in as myself, root and even created a user called informix } to try to edit it without success. } Before you even install the Informix software, you must create an owner and group called "informix". } Can this table be editted? Can I move my files? Am I doomed to } purchase a larger hard drive for this database? Answers to these and } other questions in your next newsfeed. } The table can be editted by the "informix" user provided that the permissions for certain files are OK. The permissions of your engine should be: mode=6755, owner=root, group=informix The permissions for your database directory should be: mode=770, owner=you, group=informix The permissions for all the files in your database directory should be: mode=660, owner=you, group=informix I can't promise that what you intend to do will work, but I can't really see any problems with it either. I've never tried it so let me know what happens. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.7 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com