rmoff

mv_issue_02.sql

You’ll need three files referenced from this script:

/* 

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
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: