Sorry an error in the subject of my last post: Cannot rename database if it has a virtual table or index.

Posted in 2000

Mahmoud Kamoun — Fri, 19 May 2000 12:18:26 GMT — source: Informix-list mailing list archive (1991-1998)

I tried to rename a database but I got this error: 9874: Cannot rename database if it has a virtual table or index. What is virtual table or index? is this table/index registered in the systables or in the catalog ? How can I rename the database? Thanks

↪ replying to Mahmoud Kamoun

Jonathan Leffler — Sat, 20 May 2000 05:48:33 GMT — source: Informix-list mailing list archive (1991-1998)

Mahmoud Kamoun wrote: > I tried to rename a database but I got this error: > > 9874: Cannot rename database if it has a virtual table or index.> > What is virtual table or index? > > is this table/index registered in the systables or in the catalog ? > > How can I rename the database? I suspect the answer is "Don't try to rename SysMaster". It contains a bunch of virtual tables and indexes. If it isn't SysMaster you're messing with, then we may need to knowwhether you or anyone else might have used the SQL script in the $INFORMIXDIR/etc directory that's used to create the SysMaster database... Or I could be missing something else blatantly obvious :-( -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>