Original problem back ... Frustrating..
Summary: Host:HOSTNAME Problem:Oracle SIDNAME Alert Log Msg=( ORA-2:
index "ARADMIN"."IT145" or par
Notes: Host:DHOSTNAME Problem:Oracle SIDNAME Alert Log Msg=( ORA-2:
index "ARADMIN"."IT145" or partition of such index is in unusable state )
- ful
ok, I figured out that the creating multiple indexs on a form, Fails.. but
if you add one at a time. it seems ok so far..
On Mon, Apr 9, 2012 at 4:41 PM, patrick zandi wrote:
> yeah, already did that.. found it. .but it was intermittent.. very odd,
> like 5 times a min for 4 seconds.. but the
yeah, already did that.. found it. .but it was intermittent.. very odd,
like 5 times a min for 4 seconds.. but the ars would not allow the drop..
so I decided to shutdown.. and restart.. the oracle. it cleared up.. and it
allowed the drop of indexes.. but now I cannot create indexes..
It is what
You might look into the ar.conf parameter "Read-Only-Tran-Off"
>From the docs:
"Causes AR System not to create database transactions when only
reading data."
Whether this will help or not depends on where the lock is coming from.
You can see what has a lock using this:
select do.object_name,
4 matches
Mail list logo