Re: orphan cdr_deltab... tables

>We had to "brute force" kill ER tables and rebuild awhile back (per
>Informix sup****t).
>
>I see that there are some "orphan" cdr_deltab_xxxx tables left around
>that actually "hang" dbschema when it is run on them.
>
>My question is... can these tables be manually deleted without
>cra****ng either the engine or ER?
>
>Running version "Informix Dynamic Server 2000 Version 9.21.UC5XF" on
>AIX 5.2. Yes, I KNOW, old version of Informix, Vendor is in process of
>upgrading to ver 10.

Yes you may. I have done it many times. You can always write a script
which will check the cdr_deltab with that of syscdr.deltabdef table
and see whether a row exist in that table for that cdr_deltab. if not
then it is an orphan cdr-deltab which can be deleted.