Results 1 to 4 of 4

Thread: index coalesce

  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: index coalesce

    How to coalesce partitioned index

    when i run alter index <ind_name> coalesce
    I am getting the following error
    partitioned index cannot be coalesced

    --Jaggu

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    your index is partitioned with the table.

    so:

    PHP Code:
    alter index schema.indexname modify partition partitionname coalesce
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Aug 2003
    Posts
    123
    when I execute this command I get invalid option.

    -Jaggu

    alter index schema.indexname modify partition partitionname coalesce

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    jaggu,


    post your code and the results exactly as they show in sql*plus please.

    a select from user_tab_partitions on the table in question wouldn't hurt either.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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