Toad World® Forums

Pausing index data initialization

Hi,

After waiting 4+ hours for the Index initialization step in SQL Optimizer I gave up and hit the Stop button - it is now been in the Pausing index data initialization... step for an hour.

I see a line in v$session for the optimizer and it says it has written 112 rows to the redo log and it never seems to flush them out - any ideas?

Thanks