Re: Null Table

> > WHile running checks against my Online 5.0 databases, I ran across > indexes attached to a table called "root". > > "root". seems to have no data associated to it. I've tried to drop it > without success. I can;t do a dbexport - it bombs when it hits the null > tablename, so I unloaded each table and generated a schema to rebuild the > correct tables. Unfortunately, I can't drop the database because of the > null table, to rebuild it. > > Is there any way I can drop this datbase without having to re-initialize > the entire dbspace? I have SEVERAL databases here and I dread the > thought of having to dbexport and rebuild ALL of them. > > I have no idea how this table got created, but certainly would love to > get rid of it. It's causing me all kinds of problems... > > Stuff Deleted [ .... ] Recently I encountered similar such problem on INFORMIX 5.01. Whether my approach was right on track, I am not Sure. But I got rid of that Null Table. In ISQL, SELECT tabname FROM systables WHERE tabnam is NULL; Then I created Form for Table : systables and manually assigned a dummy table name to that null table name. DROP TABLE <dummy table name>; After I dropped the table, everything was back to normal. May be U can give a try. Rgds, Anand e-mail : anand@sin-co.sin-ro.dhl.com HP-UX/9.0 INFORMIX ONLINE - 5.01