Re: Using truncate partition on running table!!

Nish apparently said,on my timestamp of 8/03/2005 10:52 PM:

> I get the following exception while inserting data,
> ---------------------------------
> "EXCEPTION :ORA-01502: index 'EVENT_IDX' or partition of such index is
> in unusable state"

On your insert jobs, add the following SQL: alter session set skip_unusable_indexes=true;

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam