Domain index needs rebuilding after move tablespace
Hi all,
I have done a bit stupid thing and now searching whether there is a quick fix to it...
I have a table that has a context/domain index on it. The index is quite big ~600G and the index creation took around 1 month.
I was stupid enough to move the table into another tablespace which means that all of the tables indexes are unusable and need rebuilding. I rebuilded all other indexes except the context index -because rebuild will probably take also 30days or so (because refresh is manual I'm able to continue using the table with the unusable index)
I have done a bit stupid thing and now searching whether there is a quick fix to it...
I have a table that has a context/domain index on it. The index is quite big ~600G and the index creation took around 1 month.
I was stupid enough to move the table into another tablespace which means that all of the tables indexes are unusable and need rebuilding. I rebuilded all other indexes except the context index -because rebuild will probably take also 30days or so (because refresh is manual I'm able to continue using the table with the unusable index)
0