RE: downgrade from 9.3 to 7.3 question
Posted in 2003
Topics: Server Administration, Triggers, Constraints & Referential Integrity
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