mv_issue_02.sql

You’ll need three files referenced from this script:

• mv_issue_02a.sql
• mv_issue_02b.sql
• mv_issue_02c.sql

/* 

mv_issue_02.sql

Materialised View - Issue 02


*/ 

-- mv_issue_02a.sql: MV using ANSI joins, re-compiled explicitly
-- Result:  ORA-12047: PCT FAST REFRESH cannot be used
--          COMPILATION_STATE: VALID
@mv_issue_02a

prompt 
prompt 
prompt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
pause Press Enter to execute next test 
prompt vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

-- mv_issue_02b.sql: MV using ANSI joins, re-compiled implicitly
-- Result:  ORA-12047: PCT FAST REFRESH cannot be used
--          COMPILATION_STATE: COMPILATION_ERROR
@mv_issue_02b

prompt 
prompt 
prompt ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
pause Press Enter to execute next test 
prompt vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

-- mv_issue_02c.sql: MV defined with Oracle-style joins
-- Result: Works
@mv_issue_02c