Re: Indexes ? or Constraints ?
From: Raghid Ajamoughli <ajamough_at_cle.ab.com>
Date: 1995/05/15
Message-ID: <3p8f2u$3b0_at_news1.cle.ab.com>#1/1
Date: 1995/05/15
Message-ID: <3p8f2u$3b0_at_news1.cle.ab.com>#1/1
> I am in the process of planing a migration from V6 to V7. Our
> V7 creation scripts have both UNIQUE declerations & CREATE UNIQUE INDEX
> comands in them. This of course won't work in 7.0
>
there are some SQL syntax changes between V6 and Oracle7, you may recode your scripts or temporarily use set compatibility:
set compatibility v6,
run your script, then set com v7,
enable your constraints by
alter table table_name
enable constraint constraint_name.
hope this helps
Raghid Ajamoughli
ajamough_at_cle.ab.com
Received on Mon May 15 1995 - 00:00:00 CEST