I think you have to recreate the indexes of the user. The best way is to export in user mode and import with indexfile= to extract index creation scripts, modify these as per your requirement and replace the old indexes.