Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Organized Table -- ORA-25182
On Mon, 25 Oct 1999 13:45:11 +0200, Joerg Lanzinger
<joerg_at_lanzinger.de> wrote:
>Hello Chris,
>
>I once ask Oracle Germany what to do when working with IOTs.
>Simple answer: Upgrade to Oracle8i (i.e. 8.1.5).
>
>A unvaluable advantage of 8i is that IOTs are now known to the optimizer
>and it will no longer try to use a FFS for each query.
>
>Hope that helps,
Thank you, Joerg. An Oracle support guy I spoke with had no problem creating it on his 8.0.6 system, but oh well.
I have 8i installed on a test server and will upgrade soon.
Chris