We are going to move tables from IQ_SYSTEM_MAIN to IQ_USER_MAIN. And there are around 1000+ FP and HG indexes build on those tables.
I understood that while moving tables we need to take care of all the associated objects( indexes/metadata/views) .I need to understand below two points-
1) I believe FP indexes/Metadata/Views will be moved Automatically while running ALTER Table MOVE TO command.Am I correct Here?
2 )Does HG indexes will also be taken care automatically or we need to move it manually?
Anything else we need to take care while moving?