March 31, 2009 at 8:59 am
Hi,
I am unable to rebuild Indexes as I am having Indexed views in place.any practical workaround pls.
The application mostly remains online and not allowed for a big enough down time where i can drop the views ... recreate indexes and create view again.
Regards,
Sriram
Sriram
June 26, 2009 at 9:24 pm
I know it has been quite awhile since you posted this question, and I was wondering two things. First, were you able to resolve the issue or is it still a problem. Two, how are you attempting to rebuild the indexes.
I have numerous indexed views in our ODS database and I just ran a script without any problems to rebuild the indexes on the underlying table of one of them.
June 28, 2009 at 12:44 pm
Hi Lynn Pettis,
So great of you, firstly thanks a lot for the commitment you are showing to help out others in this community.
There were just two many dependencies within the database, I addressed it by droping and re creating the indexes on the views and in between reindexing the indexes on tables :(....
anyways done for this time!!!
Sriram
Sriram
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply