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: adding a partition to a list partitioned table.

Re: adding a partition to a list partitioned table.

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 15 Nov 2005 11:40:00 -0800
Message-ID: <1132083687.967329@yasure>


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

Original text of this message

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