Sunday, August 31, 2008

ORA-08106: cannot create journal table ...

A "rebuild index online" Session was killed:

I found Ora errors ORA-08106:


SQL> ALTER INDEX "USER"."DATA_IDX03" REBUILD PARTITION "DATA_PART3" online;
*
ERROR at line 1:
ORA-08106: cannot create journal table USER.SYS_JOURNAL_90530

may be [oracle] still rebuild online this index.

So, I try to rebuild no online to resolve:

SQL> ALTER INDEX "USER"."DATA_IDX03" REBUILD PARTITION "DATA_PART3";

Index altered.

No comments: