ORA-01502 after drop partition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-01502 after drop partition

  1. #1
    Join Date
    Apr 2003
    Posts
    9

    ORA-01502 after drop partition

    Hi all
    I have a table that is partitioned based on month. The partitions are

    200412
    200501
    200502
    200503
    200504
    200505
    200506
    200507

    I also have an index ('WIPMON.KFLOWF_INDEX1') that is based on the table. The index is not partitioned. Yesterday I dropped the partition 200412 from the table.
    But when I performed an insert into the table today, I got the following error

    ORA-01502: index 'WIPMON.KFLOWF_INDEX1' or partition of such index is in unusable state

    What could be the cause of the problem? Must I rebuild the related indexes after I drop any partition?

  2. #2
    Join Date
    Jan 2002
    Posts
    146
    yes, u have to rebuild

  3. #3
    Join Date
    Apr 2003
    Posts
    9
    Thanks rommel
    Is there any other way that does not require rebuild?

  4. #4
    Join Date
    Jan 2002
    Posts
    146
    im afraid theres no other way

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    use local indexes - wont have this problem then

  6. #6
    Join Date
    Apr 2003
    Posts
    9
    OK
    I run the following SQL to create local indexes

    Create index 'WIPMON.KFLOWF_INDEX1' on(.....) local;

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