Re: here is another oracle 10g's bug? - Addendum

Havel Zhang wrote:
> And I did try drop and recreate index on store_product. Before
> recreate index, result is 28827. Very strange:) after I recreated this
> index, result is 64172. also wrong but close to right figure:), after
> i drop that index, i get correct result finally.

Get the ddl using:

SELECT dbms_metadata.get_ddl('TABLE', <table_name>); and
SELECT dbms_metadata.get_ddl('INDEX', <index_name>);

When the index is created and the problem exists.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org