RE: downgrade from 9.3 to 7.3 question

Hi, Chavan, Primary, foreign and unique constraints create Indexes implicitly. You should drop (not disable!!!) constraints and then, May be, drop proper indexes. ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: Chavan Koya [mailto:chavankoya189@hotmail.com] > Sent: Friday, August 15, 2003 4:12 PM > To: informix-list@iiug.org > Subject: downgrade from 9.3 to 7.3 question > > Hello All, > > I am trying to do reversion process from 9.3to 7.3 version as > you > said before. I did drop all the indexes after having the backup of all the > create index statements.> > When i try to use the command "onmode -b 7.3 ". i was getting > the > following messages > Then i looked into the dbschema out put of the table, there was no > indexes, > these (375_810) are constraints. > If i disable constraints, will i be able to do the reversion process or > should i do some thing else ? > any comments suggestions are welcome and Thanks in Advance. > > FYI : The table has been fragmented. > > >onmode -b 7.3> > This will make all necessary modifications to disk structures > so that the Informix Dynamic Server 2000 space will be compatible with > INFORMIX-OnLine Version 7.3 > Do you wish to continue (y/n)? y > Beginning process of reverting system to 7.3 ... > Table/Index 'database:"owner". 375_810 on table table name' > must be dropped or altered before using Version 7 because ... > There is a semi-detached index in this table, which cannot be reverted. > Drop indexes of this type, and retry reversion. > > _________________________________________________________________ > Polyphonic ringtones. Latest movie trailors. > http://server1.msn.co.in/sp03/gprs/index.asp On your mobile! > > sending to informix-list sending to informix-list