Re:[Fwd: Re: 10046 trace - unaccounted for time]

Can anyone tell me whether moving the blob to a different tablespace will cause the index to be rebuilt. I know the index moves so it seems like it would need to be rebuilt but just wanted to confirm.

Keith

> Thanks. We have confirmed it is some type of LOB index corruption.
>
> Insert to BLOB stored inline works fine.
> Insert to BLOB stored out of line (one row, 5MB blob) takes 4 minutes
> Insert to BLOB stored out of line (new copy of table) takes 0.125 seconds.
>
> We are now rebuilding table.
>
> Thanks to everyone for their help.
>
> Keith
>

--
http://www.freelists.org/webpage/oracle-l