11.0.1.2634 creating tracing db fails on materialized view

[MCMartin]

Creating a tracing db fails on a materialized view with a key join. The materialzed view in normal db works as expected. The related tables have a foreign key relation, so a key join is normally no problem.

Anyway the creation of the tracing db fails with: there is no way to join x and z.

Problem exists also in earlier versions like 2550

Any advice?

[Former Member · Accepted solution]

That sounds like a bug; I'll create an issue number pending reproducibility.

Note however that you don't need to create a tracing database to do tracing. You can send tracing information to any database; the only catch is that you will not be able to run some of the Recommendations if you don't have either a tracing database or a copy of the original database.

In fact, if you are in development, you can send tracing to either the local database, or to a copy of the local database that you have created.