tag:blogger.com,1999:blog-4161953958134414599.post8752777759836874331..comments2023-04-19T17:04:15.831-04:00Comments on Vijay R. Dumpa Oracle Blog: How to convert partition table into Interval Partitioning table in 11gVijay R. Dumpahttp://www.blogger.com/profile/05400068852161662003noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4161953958134414599.post-27332743774407922382013-09-30T17:33:33.590-04:002013-09-30T17:33:33.590-04:00Corrected that, we can only do this during Index c...Corrected that, we can only do this during Index creation.Vijay R. Dumpahttps://www.blogger.com/profile/05400068852161662003noreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-46564345383599783122012-07-25T02:05:45.207-04:002012-07-25T02:05:45.207-04:00Hi Vijay,
I have created partitioned table with i...Hi Vijay,<br /><br />I have created partitioned table with interval partition and created a index on particular column, but when I am altering index with set store in it is throwing error.<br /><br />SQL> alter index MOS_DNN_TEMP_I set store in (ID_ADMIN);<br />alter index MOS_DNN_TEMP_I set store in (ID_ADMIN)<br /> *<br />ERROR at line 1:<br />ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option<br /><br /><br />Can we use set store in option for an INDEX?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4161953958134414599.post-42463836646264599252012-03-25T21:32:37.747-04:002012-03-25T21:32:37.747-04:00briliant!briliant!Anonymousnoreply@blogger.com