Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: here is another oracle 10g's bug? - Addendum

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 20 Jun 2007 06:24:25 -0700
Message-ID: <1182345862.833520@bubbleator.drizzle.com>


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
Received on Wed Jun 20 2007 - 08:24:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US