Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Embarasing question ....

RE: Embarasing question ....

From: Richard J. Goulet <>
Date: Mon, 14 May 2007 11:38:14 -0400
Message-ID: <>

AH, another missing piece of the puzzle, we're talking about function based indexes. Well if the function that was used to create the index was rebuilt/modified that would explain everything. Especially if it's a non oracle provided function.

Dick Goulet / Capgemini
North America P&C / East Business Unit
\Senior Oracle DBA / Outsourcing
Office: 508.572.1978 / Mobile: 508.742.5795 / Fax: 508.229.2019
45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience

-----Original Message-----
From: Norman Dunbar [] Sent: Monday, May 14, 2007 11:31 AM
To:; Richard J. Goulet Cc:
Subject: Re: Embarasing question ....


thanks for that. The problem I'm having doesn't have DDL run on anything (production database) but something did cause a pile of indexes to go invalid (under DBA_OBJECTS) but left them showing up as valid under DBA_INDEXES - that's where I got caught out!

These are 'user defined indexes' in that they are based on an index type and there is object type body that 'appears' to contain the code for using (abusing) said indexes based on the index type. I've never done that sort of stuff before, so I've (currently) got no idea what's going on.

I've been given a script to rebuild these indexes and that has worked ok, and the system is working fine now - but I'm worried about what made it break in the first place.


>> "Rumpi Gravenstein" <> 05/11/07 06:15PM >>>
>> I've seen similar issues. In my case the problem was in having had
run DDL
>> (grants) through that causes a revalidation of associated objects.
If an

Norman Dunbar.
Contract Oracle DBA.
Rivers House, Leeds.

Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at

Received on Mon May 14 2007 - 10:38:14 CDT

Original text of this message