Re: Partitioned View Select Problem

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Wed, 17 Feb 1999 10:29:00 -0800
Message-ID: <36CB0A6C.B08ED85C@earthlink.net>

You are probably running on Oracle 7.3.2... 7.2..... or 7.3.3.... gotta go to 7.3.4 better to 8.0.5

Your indexes are corrupted, even if you rebuld your index the problem will comeback very soon, and eventually you'll find yourself cleaning your database from corrupted tables. -- Make a switch

ASAP !!!!!! PS if you want to take chances and run on 7.3 here is how to find out corrupted tables/indexes

run this script:

---

/** created by Vitaliy Mogilevskiy 08-28-1998**/
/** vit100gain_at_earthlink.net **/

set term on

accept owner_name char prompt "Enter Schema Name [Enter For All]:" prompt
prompt Generating dinamic SQL to analize tables prompt This will take some time on large databases prompt

set term off
SET PAGESIZE 0
set feedback off

select 'analyze table '||owner||'.'||table_name||' validate structure cascade;'
from
dba_tables
where owner = nvl(upper('&OWNER_NAME'),owner)

SPOOL tb.tmp

prompt spool tb_out.lst
prompt set term on
prompt prompt
prompt prompt Running SQL to validate tables prompt prompt This will take some time on large databases prompt prompt
prompt set term off
/
prompt spool off
prompt set term on
prompt set feedback on

prompt prompt ========================================

prompt prompt Please Review the output file tb_out.lst prompt prompt For validation errors !!!!!!

prompt prompt ========================================

SPOOL OFF
@tb.tmp

Vitaliy Mogilevskiy Received on Wed Feb 17 1999 - 12:29:00 CST