RE: value from index block or table block

Let me get this straight: You are experiencing the return of incorrect
values (meaning either a bug or a corruption) and Oracle Support will not
authorize your use of setting an event either at the session or system
level?

a) Have you asked on your SR? Denying your suggestion of using a diagnostic
likely to show the problem would create both an interesting legal situation
and a troubling review situation for the support analysts involved when you
escalate the call.
b) Make a physical clone using OS level tools and do it there. A physical
clone will not repair anything.

Alter session rather than alter system should be sufficient. That was a
sloppy cut and paste.

"Our customers are not sheep to be shorn." - An oracle executive I won't
out.

Don't be a sheep.

Regards,

mwf

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Grzegorz Goryszewski
Sent: Thursday, November 24, 2011 12:22 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: value from index block or table block

On 2011-11-24 10:44, Mark W. Farnham wrote:
> This is a good case for
> ALTER SYSTEM SET EVENTS '10046 trace name context forever, level 12'; 
> drop table <table_name>; exit;
>
> to see what is actually going on. Since a drop is actually a long list 
> of sql's and proc's, something like
>
> drop
> --+ gather_plan_statistics
> <table_name>;
>
> f
Thanks Mark,
We actually did that some time ago, but Oracle support does not allow that .
Fortunately looks like, during upgrade to 11g the new index is created on
obj$ in place of old with new columns so upgrade should solve our problem in
supported way or just fail :) Regards GregG

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: