This kind of error i saw in our production database.
so first i checked that index status in all_indexes view, it was in unusable state. after that i tried to rebuild that index with that particular table_owner. for that i issued the below query.
sql>alter index table_owner.index_name rebuild online;
but it was giving the below error
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
then i checked in all_indexes view that index is partitioned or not but it was not partitioned then i issued the below query so that became unusable state to valid.
sql>alter index table_owner.index_name rebuild parallel;
The above query causes the index to be rebuilt from the existing index by using parallel execution processes to scan the old and to build the new index
so first i checked that index status in all_indexes view, it was in unusable state. after that i tried to rebuild that index with that particular table_owner. for that i issued the below query.
sql>alter index table_owner.index_name rebuild online;
but it was giving the below error
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
then i checked in all_indexes view that index is partitioned or not but it was not partitioned then i issued the below query so that became unusable state to valid.
sql>alter index table_owner.index_name rebuild parallel;
The above query causes the index to be rebuilt from the existing index by using parallel execution processes to scan the old and to build the new index
No comments:
Post a Comment