The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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?

asked 27 Jul '11, 11:36

Martin's gravatar image

accept rate: 14%

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.

permanent link

answered 28 Jul '11, 22:12

Dan%20Farrar's gravatar image

Dan Farrar
accept rate: 80%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 27 Jul '11, 11:36

question was seen: 537 times

last updated: 28 Jul '11, 22:12