| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Index rebuild problem
Hi,
On Oracle 8.1.5/Solaris 2.6, I've tried to rebuild an index in a different tablespace using "alter index xxx rebuild online tablespace yyyy;".
I had an ORA-3113 during the process.
Now, the index is still in the bad tablespace,
when doing another alter index rebuild I have a
ORA-08106: can not create journal table
HOURA.SYS_JOURNAL_9631
when doing a drop of the index I have ORA-08104: this
index object 9631 is being online built or rebuilt.
If doing an explain plan I see that Oracle still uses the index to access the table .
Doing an analyze index validate structure reports no error.
How can I change that index not to be in the rebuild
mode ? I still want to move that index.
This is a 24 hour system I do not have a time window
to drop the table and rebuilt it.
 |
 |