Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PROBLEM: Cannot rebuild index!!

Re: PROBLEM: Cannot rebuild index!!

From: BD <bobby_dread_at_hotmail.com>
Date: 30 Dec 2005 12:05:06 -0800
Message-ID: <1135973106.734050.78140@g44g2000cwa.googlegroups.com>


I found out why the dupes came into play:

We drop indexes, then do the inserts from the remote db, and re-enable the indexes. It's entirely possible that the source db has made some changes to how they index their tables.

We'll have to contact the dbas of the source db and see if they've made some RI changes somewhere...

Blissfully, this particular dataset is not yet in use by anyone, so if it's broken we won't suffer. ;) Received on Fri Dec 30 2005 - 14:05:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US