Re: Embarasing question ....
- From: "Norman Dunbar" <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <rgravens@xxxxxxxxx>, <rgoulet@xxxxxxxxxx>
- Date: Mon, 14 May 2007 16:30:57 +0100
Afternoon,
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.
Cheers,
Norman.
>> "Rumpi Gravenstein" <rgravens@xxxxxxxxx> 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
<SNIP>
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 www.environment-agency.gov.uk
--
//www.freelists.org/webpage/oracle-l
Other related posts:
