0

I have table which partitioned by date and index is different table space. So first I tried this query.

ALTER TABLE USER.XXX TRUNCATE SUBPARTITION SP_201508_D11 UPDATE GLOBAL INDEXES;

But it's never finish.

So removed this part UPDATE GLOBAL INDEXES and it was truncated very fast. After that my index is broken then run following query.

ALTER INDEX USER.IDX_XXX
REBUILD
NOCOMPRESS
NOPARALLEL
TABLESPACE TB_S
STORAGE (
         INITIAL     64K
         NEXT        10M
        )

And it's looks also never finish. How can I handle this issue? Index size is about 50GB.

halfer
  • 19,824
  • 17
  • 99
  • 186
user347918
  • 161
  • 1
  • 2
  • 11
  • How long have you left it running? I expect it will finish, it will just take longer than you have left it. – halfer Nov 19 '15 at 21:17
  • 1 hour then it inactive, our network can keep session for just 1 hour – user347918 Nov 19 '15 at 21:52
  • 2
    If your problem is that your network is killing the connection before the statement completes, you'd want to submit a job to do the alter that can run on the server without needing your connection to remain up. – Justin Cave Nov 19 '15 at 22:41
  • OK, how long do you want it to take? It is possible that it will just take over an hour (see Justin's advice). – halfer Nov 20 '15 at 12:49

0 Answers0