Re: value from index block or table block

From: Grzegorz Goryszewski <>
Date: Thu, 24 Nov 2011 18:22:21 +0100
Message-ID: <>

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 :)
Received on Thu Nov 24 2011 - 11:22:21 CST

Original text of this message