DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006

    Question indexes are in N/A status

    Hi All,
    I have created an index on a partition table. But the index is in N/A status, Index is composite index (on 6 columns). All columns are there in table.

    How can i make it in valid status ?

    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    look in user_ind_partitions, not user_indexes

  3. #3
    Join Date
    Apr 2001
    Bangalore, India
    This is normal. You have created local indexes for a partitioned table.
    SQL> Create table emp (
      2  Emp number,
      3  Name varchar2(20))
      4  Partition by range (emp)
      5  (Partition emp1 values less than (100),
      6  Partition emp2 values less than (200),
      7  Partition emp3 values less than (300));
    Table created.
    SQL> select index_name from user_indexes where table_name='EMP';
    no rows selected
    SQL> CREATE INDEX ind_emp ON emp(emp) LOCAL;
    Index created.
    SQL> select index_name ,status from user_indexes where table_name='EMP';
    INDEX_NAME                     STATUS
    ------------------------------ --------
    IND_EMP                        N/A
    SQL> select INDEX_NAME,PARTITION_NAME,STATUS from user_ind_partitions;
    INDEX_NAME                     PARTITION_NAME                 STATUS
    ------------------------------ ------------------------------ --------
    IND_EMP                        EMP2                           USABLE
    IND_EMP                        EMP3                           USABLE
    IND_EMP                        EMP1                           USABLE
    See the USER_IND_PARTITIONS for the actual STATUS.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.