SEO

Hello people,

I have this strange error:

ORA-08114: can not alter a fake index

The only solution searching in the internet (metalink, groups) that I
found is to drop the index.

Anyone encountered this before?

Thanks

<DMina@laiki.com> a écrit dans le message de
news:1106424133.129103.98370@c13g2000cwb.googlegro ups.com...
| Hello people,
|
| I have this strange error:
|
| ORA-08114: can not alter a fake index
|
| The only solution searching in the internet (metalink, groups) that I
| found is to drop the index.
|
| Anyone encountered this before?
|
| Thanks
|

Have a look at:

http://www.databasejournal.com/featu...le.php/3413961

Regards
Michel Cadot

"Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <DMina@laiki.com> a écrit dans le message de
> news:1106424133.129103.98370@c13g2000cwb.googlegro ups.com...
> | Hello people,
> |
> | I have this strange error:
> |
> | ORA-08114: can not alter a fake index
> |
> | The only solution searching in the internet (metalink, groups) that I
> | found is to drop the index.
> |
> | Anyone encountered this before?
> |
> | Thanks
> |
>
> Have a look at:
>
> http://www.databasejournal.com/featu...le.php/3413961

Interesting. I see how you can use a fake index to trick the CBO
into given you a hypothetical execution path, but in that example
the query was actually run. How do you actually run a hypothetical
execution plan?

Xho

--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB

<xhoster@gmail.com> a écrit dans le message de news:20050122221140.418$4E@newsreader.com...
| "Michel Cadot" <micadot{at}altern{dot}org> wrote:
| > <DMina@laiki.com> a écrit dans le message de
| > news:1106424133.129103.98370@c13g2000cwb.googlegro ups.com...
| > | Hello people,
| > |
| > | I have this strange error:
| > |
| > | ORA-08114: can not alter a fake index
| > |
| > | The only solution searching in the internet (metalink, groups) that I
| > | found is to drop the index.
| > |
| > | Anyone encountered this before?
| > |
| > | Thanks
| > |
| >
| > Have a look at:
| >
| > http://www.databasejournal.com/featu...le.php/3413961
|
| Interesting. I see how you can use a fake index to trick the CBO
| into given you a hypothetical execution path, but in that example
| the query was actually run. How do you actually run a hypothetical
| execution plan?
|
| Xho
|
| --
| -------------------- http://NewsReader.Com/ --------------------
| Usenet Newsgroup Service $9.95/Month 30GB

The OP did not say he executed a query, he only said he got an ORA-08114 error.
You can't really use a virtual index in a query, you just seem to use it in explain plan/autotrace.
This is the purpose of virtual indexes. If you can really use them why do you create a real index
anymore?

Regards
Michel Cadot

This is just another example of explain plan (invoked
by autotrace) giving you a plan that did not (or in
this case could not) happen.

--
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Dec 23rd 2004






> <xhoster@gmail.com> a écrit dans le message de
> news:20050122221140.418$4E@newsreader.com...
> |
> | Interesting. I see how you can use a fake index to trick the CBO
> | into given you a hypothetical execution path, but in that example
> | the query was actually run. How do you actually run a hypothetical
> | execution plan?
> |
> | Xho
> |

"Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <xhoster@gmail.com> a écrit dans le message de
> news:20050122221140.418$4E@newsreader.com...
> | "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> | >
> | > Have a look at:
> | >
> | > http://www.databasejournal.com/featu...le.php/3413961
> |
> | Interesting. I see how you can use a fake index to trick the CBO
> | into given you a hypothetical execution path, but in that example
> | the query was actually run. How do you actually run a hypothetical
> | execution plan?
> |
>
> The OP did not say he executed a query, he only said he got an ORA-08114
> error.

I wasn't refering to the OP, but to one of the examples in the link
you posted.

Xho

--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB