Re: sysconstraints!!

->From: daemous@illuminati.io.com (Daemous Riel) ->Subject: sysconstraints!! ->Date: 23 May 1994 16:28:40 GMT ->Reply-To: clay@unipress.com ->Organization: Asylum Thoughtrights, Inc. -> ->Help! All of a sudden I find out I can't delete tables or modify my ->table schemas... code 311 (sysconstra). I look at my sys files and ->note that I don't have a syscontra.dat... only a syscontra.idx. These ->might have gone away during a filesystem restore. Is this my problem? ->How might I fix it? -> ->--cw ->_______________________________ . _______________________________________ -> /?\\ -> Clay Webster /???\\ "Now I know why they call television -> daemous@illuminati.io.com /?? ??\\ a medium. It's neither rare, nor -> Database Programmer /???????\\ very well done." -- Mighty Mouse ->__________________________ +MDCCLXXVI+ __________________________________ -><a HREF="http://www.unipress.com/people/clay/">Extra Goodie Finger Info</a> -> Did you have any constraints defined? If so, then you need to reload the sysconstra.dat file from some backup. If not, then one approach would be to touch sysconstra.dat in the appropriate dbname.dbs directory. You should change ownership and permissions on this new file to match the others in your database. The empty file created by touch should be all you need. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\