Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: adding a partition to a list partitioned table.
mail2atulmehta_at_yahoo.com wrote:
> I got it. I have to use the alter index SYS .. It is working now
> BTW: I did include the ful error msg in my first posting & not my
> interpretation of it.
> the error msg was;
> ERROR at line 1:
> ORA-01502: index 'SYS.SYS_C005405' or partition of such index is in
> unusable state.
>
> my next question is how to avoid getting the error msg, altogether. Can
> I do something in the create table statement which in future will help
> me avoid this msg..
> thanks
Since you never provided the information necessary to understand what was going on no help is possible.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Nov 15 2005 - 13:40:00 CST