RE: Naming standards -- that lead to implicit/explicit constraint and index creation.

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Thu, 17 Nov 2011 14:16:13 +0100
Message-ID: <4814386347E41145AAE79139EAA398981939BEE6E1_at_ws03-exch07.iconos.be>



Hey
In attach you will find an example which shows an implicit unique index not being recreated during import because the constraint is using an explicit index instead. Also note the failed import of some of the index_statistics, which can act as a red flag to detect such a case.

Regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

---
From: Joel.Patterson_at_crowley.com [mailto:Joel.Patterson_at_crowley.com] 
Sent: woensdag 16 november 2011 20:47
To: D'Hooge Freek; oracle-l_at_freelists.org
Subject: Naming standards -- that lead to implicit/explicit constraint and index creation.


 
Oracle version 10.2.0.4
 
I would appreciate an example where an Index is created such that by creating an implicit primary key or unique index on the table, would cause one of the indexes not to be imported. ... -- http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 17 2011 - 07:16:13 CST

Original text of this message