Synchronization Wizard weirdness

From: A Nice Guy <mrh_at_panix.com>
Date: Wed, 15 Feb 2006 21:26:57 +0000 (UTC)
Message-ID: <dt06b1$f2n$1_at_reader2.panix.com>

Hi All,
[Quoted] [Quoted] I'm an old-time Informix DBA who has now switched over to Oracle. I've been learning the Oracle packages as I go.

I have a Test Schema in the same database as the Main schema and need to synchronize Test with Main (all table & data mods).

[Quoted] [Quoted] All seems to go well, until the script actually runs. The Impact Report only has warnings, but the Script fails.

[Quoted] [Quoted] The problem: When the Sych script modifies a table, it renames the original table. *** But it doesn't rename or drop the indexes on the table *** so when it tries to recreate the index, the script fails because "an index with that name already exists in the database".

[Quoted] [Quoted] Any idea what to do about this??? I'll take any suggestion and test it.

Thanks,
Michael Hoffman Received on Wed Feb 15 2006 - 22:26:57 CET