RE: dbms package? - analyze table validate structure

Tim,
 
Yes, That I what I meant. However, my this experience was with (alter 
)rebuidling of indexes using parallel clause. However, I did not use with 
CREATE INDEX this clause but I think the problem was with alter index only.
 
It was originally with 7.3.4.3 version as I did not had any bad experience with 
7.3.4.4. But again it came up in 7.3.4.5 which needed it to patch again. If I 
remember correctly it was year 2001/2.
 
I was supporting Oracle Finacial databases and I have to rebuilt indexes after 
reorg of tables (after yearly data purging)  with large undexes and I got this 
issue with 7.3.4.3. I had done similar excercise with other client with 7.3.4.4 
but no issue with that version.  Later I observed that this issue is with 
indexes having multiple keys. For both versions patch was available to fix that 
issue.
 
One year back one of my collegue had similar type of issue with 9.X version. I 
don't know exact version but she has to drop and recreate index again and the 
issue was resolved. She then upgraded her database to 9.2.0.8 later and did not 
observe such issue.
 
Regards
Rafiq
 
 
 
 
 
 
> Date: Wed, 31 Dec 2008 14:47:08 -0700> From: tim@xxxxxxxxx> To: 
> rafiq9857@xxxxxxxxxxx> CC: jkstill@xxxxxxxxx; jon.crisler@xxxxxxx; 
> oracle-l@xxxxxxxxxxxxx> Subject: Re: dbms package? - analyze table validate 
> structure> > Rafiq,> > Regarding your comment...> > The issue is always using 
> parallel caluse on a index with multiple > > keys. Single key indexses has no 
> issues.> Do you mean to say that the PARALLEL clause in CREATE | ALTER INDEX 
> is > somehow affected by the number of columns or expressions specified in > 
> the index? Can you elaborate or substantiate?> > Thanks!> > -Tim> --> 
> http://www.freelists.org/webpage/oracle-l> > 
_________________________________________________________________
Send e-mail anywhere. No map, no compass.
http://windowslive.com/oneline/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_anywhere_122008

Other related posts: