Re: value from index block or table block

From: Grzegorz Goryszewski <grzegorzof_at_interia.pl>
Date: Thu, 24 Nov 2011 18:22:21 +0100
Message-ID: <4ECE7D4D.5020309_at_interia.pl>

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

Received on Thu Nov 24 2011 - 11:22:21 CST