you may be helped by this:
run dbverify to fix that corruption..if it is at Oracle level that will take care of it.
after that:
create temp_x as select * from x
extract the index definitions on x or note on ehich columns you have indexes and what type. also constraints.
drop table x
rename temp_x as x and recreate the indexes.
enable constraints.




Reply With Quote