Skip to Main Content
  • Questions

  • ORA-22165: given index error encountered when adding a materialized view in a materialized view group

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: September 04, 2018 - 1:45 am UTC

Last updated: September 04, 2018 - 7:15 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hi,

We dropped and re-created a materialized view group and would like to add it in a certain materialized view group but an ORA-22165 is encountered when trying to add the materialized view in an existing group. Can I ask how this is encountered?

and Connor said...

CRYSTAL_BALL

I'm looking in my crystal ball... I'm trying to see

- your DDL
- your test script
- the full error message stack...

Nope... can't see any of that :-(

Seriously... you gotta give us at least something to work with here.

I am *guessing* that MOS note 21472469.8 might be relevant...but I'm *guessing*.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Design

New to good database design? Check out Chris Saxon's full fundamentals class.