Online Rebuilding Index Problem [message #57194] |
Tue, 27 May 2003 23:21 |
Prasad
Messages: 104 Registered: October 2000
|
Senior Member |
|
|
Hi All
I am encountering this error when try to build an index online
ORA-08106 can not create journal table string.string
I found the cause and action for this
Cause: Online index builder cannot create its journal table.
Action: Rename your table in conflict.
But Somebody can explain me in detail to solve this problem, I didn't find any solution noteven metalink either, I guess this is something related to creating
some temporary tables while rebuilding the online so
that whatever the changes will be available in the temporary table and concurently users query on the table by using index, But Some tell me how to resolve this issue, What corrective and preventive action needs to taken to avoid such errors.
U'r Help Will be greatly appectiated.
I am facing this problem for 9.2.0.3.0
Thanks
Prasad
|
|
|