What Oracle Version ?
Are materialized view and base table in same database or is there a database link between ? - If yes, what's the Oracle Version on the other side of the database link ?
Do you use in "create materialized view ..." a synonym for the table accessed ?




Reply With Quote