Create unique index on 2 columns does not work ! -- sql server replication

rrouma
10/14/2004 7:45:02 AM

Hello,
I need to replicate tables from SQLServer 2000 to Oracle 9.2
Using MDAC 2.8 & Oracle ODBC driver -
1-An index on 2 columns for a table exists but when it is created on oracle
only first column is used. The idx script contains right declaration : CREATE
UNIQUE INDEX [pk_nivprev] ON [nivprev]([niv_dat], [pers_mat]) WITH
FILLFACTOR = 90 but on Oracle the index is created only on niv_dat. Any idea
?
2-With SQLServer 7 i was able to create table without index but not in
SQLServer 2000. When i unmark integrity constraint in article properties
nonclustered index is mark automatically. Any other good idea ?

rrouma
10/14/2004 8:49:14 AM

My first problem is solved : I now use MS ODBC Driver for Oracle instead of
Oracle ODBC Driver.
Any idea to avoid index creation ?
Thanks

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Create unique index on 2 columns does not work !