Home » RDBMS Server » Server Administration » Online Rebuilding Index Problem
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
Previous Topic: Problem with Analyze
Next Topic: ora-12535
Goto Forum:
  


Current Time: Fri Sep 20 03:25:10 CDT 2024