|
Oct 26 2009, 10:50 AM EDT
|
olapdba
|
|
edit |
10 words added
10 words deleted
|
|
Change: ................................................................................Build... Refresh..Refresh..RefreshCube Materialized View ....................ReWrite Mode.....Mode.... Method...Last Date Staleness -------------------------------------------------------------- ------- -------- --------. -------- --------- ----------------------------DM.CB$CHANNEL_SALES_CHANNEL ........ N...... DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH.............. DM.CB$CUSTOMER_REGIONAL ................ N
View changes from previous version.
(Word count: 163)
|
|
Feb 13 2008, 11:17 AM EST
|
olapdba
|
|
edit |
2 words added
1 word deleted
|
|
Change: cube_mv,rewrite_enabled,cube_mv,rewrite_enabled, refresh_mode,refresh_method,last_refresh_date,staleness from all_mviews where container_name like 'CB$%' order by cube_mv;............................................Build... Refresh..Refresh..RefreshCube Materialized View..............ReWrite Mode.....Mode.... Method...Last Date Staleness----------------------------------- ------- -------- --------.--------- -------------------DM.CB$CHANNEL_SALES_CHANNEL........ N...... DEFERRED.DEMAND
View changes from previous version.
(Word count: 163)
|
|
Feb 13 2008, 11:16 AM EST
|
olapdba
|
|
edit |
3 words added
1 word deleted
|
|
Change: cube_mv,rewrite_enabled,refresh_mode,refresh_method,last_refresh_date,stalenesscube_mv,rewrite_enabled,refresh_mode,refresh_method,last_refresh_date,staleness from all_mviews where container_name like 'CB$%' order by cube_mv;............................................Build... Refresh..Refresh..RefreshCube Materialized View..............ReWrite Mode.....Mode.... Method...Last Date Staleness----------------------------------- ------- -------- --------.--------- -------------------DM.CB$CHANNEL_SALES_CHANNEL........ N...... DEFERRED.DEMAND...
View changes from previous version.
(Word count: 163)
|
|
Feb 13 2008, 11:15 AM EST
|
olapdba
|
|
edit |
|
|
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 163)
|
|
Jan 11 2008, 10:56 AM EST
|
olapdba
|
|
edit |
22 words added
|
|
Change: build_mode for a8 hea 'Build|Mode'col refresh_mode for a8 hea 'Refresh|Mode'col refresh_method hea 'Refresh|Method'col last_refresh_date hea 'Refresh|Last Date' col staleness hea 'Staleness' select owner||'.'||mview_name cube_mv,rewrite_enabled,refresh_mode,refresh_method,last_refresh_date,staleness from all_mviews where container_name like 'CB$%' order by cube_mv;............................................ Build... Refresh..Refresh..RefreshCube Materialized View..............ReWrite Mode
View changes from previous version.
(Word count: 163)
|
|
Jan 11 2008, 10:50 AM EST
|
olapdba
|
|
edit |
75 words added
64 words deleted
|
|
Change: and object_name=container_name and o.owner=m.owner group by o.owner,mview_name,rewrite_enabled,staleness,created,status order by cube_mv; ............................................Refresh..Refresh..RefreshCube Materialized View ........................... ReWrite StalenessMode................CreatedMethod..............StatusLast Date Staleness----------------------------------- ------- --------------------------- -------------------------.--------- -------------------------DM.CB$CHANNEL_SALES_CHANNEL........ N...... FRESHDEMAND
View changes from previous version.
(Word count: 148)
|
|
Jan 10 2008, 12:43 PM EST
|
olapdba
|
|
edit |
8 words deleted
|
|
Change: .......FRESH...............21-SEP-2007 11:05 VALIDDM.CB$PRODUCT_STANDARD..............N.......FRESH...............21-SEP-2007 11:07 VALIDDM.CB$SALES_CUBE....................Y.......FRESH...............21-SEP-2007 11:10 VALIDDM.CB$TIME_CALENDAR.................N.......FRESH...............21-SEP-2007 11:07 VALIDDM.CB$TIME_FISCAL...................N.......FRESH...............21-SEP-2007 11:07 VALID Determine Creation Data for Cube Organized Materialized Views
View changes from previous version.
(Word count: 164)
|
|
Jan 10 2008, 12:42 PM EST
|
olapdba
|
|
edit |
95 words added
30 words deleted
|
|
Change: .......FRESH ...............DM.CB$PRODUCT_STANDARD21-SEP-2007 11:07 VALIDDM.CB$SALES_CUBE.................... N Y................. FRESH ...............DM.CB$CUSTOMER_REGIONAL21-SEP-2007 11:10 VALIDDM.CB$TIME_CALENDAR.................................... N ................. FRESH ...............DM.CB$TIME_CALENDAR21-SEP-2007 11:07 VALIDDM.CB$TIME_FISCAL.......................................... N ................. FRESH ...............21-SEP-2007 11:07 VALIDDetermine Creation Data for Cube Organized Materialized Views
View changes from previous version.
(Word count: 172)
|
|
Jan 9 2008, 12:53 PM EST
|
olapdba
|
|
edit |
10 words deleted
|
|
Change: Determine Existence and ReWriteability of Cube Organized Materialized Views (11.1.0)This script will allow you to determine the existence of Materialized Views generated via the OLAP option.set pages 500col cube_mv hea 'Cube Materialized View'col rewrite_enabled for a12 hea 'ReWriteable'col staleness hea 'Staleness' select owner||'.'||mview_name cube_mv,rewrite_enabled,staleness from
View changes from previous version.
(Word count: 83)
|
|
Jan 9 2008, 12:30 PM EST
|
olapdba
|
|
edit |
95 words added
|
|
Change: This script will allow you to determine the existence of Materialized Views generated via the OLAP option.set pages 500col cube_mv hea 'Cube Materialized View'col rewrite_enabled for a12 hea 'ReWriteable'col staleness hea 'Staleness' select owner||'.'||mview_name cube_mv,rewrite_enabled,staleness from all_mviews where container_name like 'CB$%'; Cube Materialized View .................... ReWriteable
View changes from previous version.
(Word count: 95)
|
|
Jan 9 2008, 12:28 PM EST
|
olapdba
|
|
create |
No content added or deleted. |
|
Change: Created by Jan 9 2008, 12:28 PM EST for: no reason given
|