A Wetpaint Site

Determine Existence and ReWriteability of Cube Organized Materialized Views (11.1.0)

Page Versions
To-Dos

Key: additions deletions

	Date/Time	Made By	Type	Scope
	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 VALIDDetermine 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 olapdba Jan 9 2008, 12:28 PM EST for: no reason given

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home