Normally you can get extra tables involved
with an MV by creating a Dimension that
describes all the relationships between the
tables in the MV and the tables outside the
MV - but the only times I've done this, the
extra tables have always been at the parent
end of a parent/child link to a table i
materialized view needs to be reloaded. This could take a little while.
>
> From: [EMAIL PROTECTED]
> Date: 2003/12/26 Fri PM 02:09:27 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: please help with materialized view question
>
> Warnin
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: please help with materialized view question
I figured it out.
I have another problem. I create my materialized view. I now want to write a query that joins it to a transactiona
I figured it out. I need some help with query re-write. Im not sure its possible.
My materialized view joins 3 tables on the primary key/foreign key. I have a query
that would join that materialized view to a third transactional table, but that join
is not on any primary key or foreign key.
I
public synonym?
To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
I figured it out.
I have another problem. I create my materialized view. I now want to write a query
that joins it to a transactional table. I want to use query rewrite. Problem is the
join is not on the primary key of either table.
Is it possible to enable query rewrite without that? I have