Re: database error involving file()

Clem Akins (cwakins@leia.alloys.rmc.com) wrote: : } I receive the following error when I try to drop : } a database. I also cannot drop dbspaces or : } blobspaces even after I drop the tables that utilize : } to them. How can I look further for the problem : } that is generating this error. This is a real-time : } database, so of course, speed is of the essence! (actually, Clem was replying to Carol Stimmel (sp?) who had a problem dropping dbspaces> Carol, I've had the same problem becuase of corruption in the system tables or in the pseudotables in the rootdbs. Sometimes I have been able to get rid of the problems by cleaning out the system tables of all references to "phantom tables" (risky move, though). Most times, I've had to call Support. They called in, twiddled some bits with the (infamous) tbpatch program, and all was well. What they did is change the bits that indicated what type of space it was....for some reason, it was easiest if they made OnLine think that these were BLOB-spaces.... Call support. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) Dallas, Texas ----------------------------------------------------------------------------