Re: Trouble dropping tables
In article <3v89r8$fjd@cssun.mathcs.emory.edu>
Mark.Denham@bbc.co.uk "Mark Denham" writes:
> Kate wrote:
> >I have a database that I can't save the structure of (with dbschema) as
> >there's a weird table in it and dbschema falls over when it comes to it.
<snip>
Mark wrote:
<snip>
> You have not mentioned whether the db is SE/Online.
Before using Mark's suggetion of deleting relevent rows from the system
catalogues as 'informix', you could also:
Try dropping it as 'informix';
Check the physical files exist (if SE);
Check they are'nt odd UNIX perms (if SE) - they should be
664 and in group 'informix'.
If the database is SE you can also (from the shell) run 'bcheck' on all
the system catalogues, just in case!
I'm sure there's an OL equivalent but I don't know what it is!
--
============================================================================
Sally Woolrich | This mail contains my personal
sally@excelsis.demon.co.uk | views not those of my employer!
============================================================================