A Wetpaint Site

Determine Object Dependencies

Page Versions
To-Dos

Key: additions deletions

	Date/Time	Made By	Type	Scope
	Apr 28 2008, 11:36 AM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 332)
	Apr 28 2008, 11:34 AM EDT	olapdba	edit	20 words added 19 words deleted
Change: 'CUBE.DIMENSION','CUBE.DIM''CUBE.DIMENSION','CUBE.DIM', type)\|\|')' objdep, referenced_name\|\|' ('\|\|decode(referenced_type, 'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT','NO-EXIST', 'PACKAGE BODY','PKGBDY', 'CUBE.DIMENSION','CUBE.DIM', referenced_type)\|\|')' refrfrom dba_dependencies where owner=:usn order by objdep; Object Name (Type).......................Object Reference (Type)---------------------------------------- -----------------------------------DM.CB$CHANNEL_SALES_CHANNEL (MV) ..............CHANNELS (TABLE).........................................CB$CHANNEL_SALES_CHANNEL (TABLE)DM.CB$CUSTOMER_REGIONAL (MV) ......................CUSTOMERS (TABLE).........................................COUNTRIES (TABLE) View changes from previous version. (Word count: 332)
	Apr 28 2008, 11:32 AM EDT	olapdba	edit	15 words added 11 words deleted
Change: .. ............TIMES (TABLE).........................................CB$TIME_CALENDAR (TABLE)DM.CB$TIME_FISCAL (MVIEW)(MV) ................TIMES (TABLE).........................................CB$TIME_FISCAL (TABLE)DM.CHANNEL (CUBE.DIM) ................. ...........AW$DM (TABLE)DM.CHANNELS_DIM (DIM)....................CHANNELS (TABLE)DM.CHANNEL_SALES_CHANNEL_VIEW (VIEW).....CUBE_TABLE (SYNONYM).........................................OLAPIMPL_T (TYPE.BODY).........................................CHANNEL (CUBE.DIMENSION)DM.CHANNEL_VIEW (VIEW)...................CHANNEL (CUBE.DIMENSION).........................................CUBE_TABLE (SYNONYM).........................................OLAPIMPL_T (TYPE.BODY) View changes from previous version. (Word count: 328)
	Apr 28 2008, 11:30 AM EDT	olapdba	edit	4 words added 3 words deleted
Change: 'CUBE.DIMENSION','CUBE.DIM' type)\|\|')' objdep, referenced_name\|\|' ('\|\|decode(referenced_type, 'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT','NO-EXIST', 'PACKAGE BODY','PKGBDY', referenced_type)\|\|')' refrfrom dba_dependencies where owner=:usn order by objdep; Object Name (Type).......................Object Reference (Type)---------------------------------------- -----------------------------------DM.CB$CHANNEL_SALES_CHANNEL (MVIEW)......CHANNELS (TABLE).........................................CB$CHANNEL_SALES_CHANNEL (TABLE)DM.CB$CUSTOMER_REGIONAL (MVIEW)..........CUSTOMERS (TABLE).........................................COUNTRIES (TABLE).........................................CB$CUSTOMER_REGIONAL (TABLE)DM.CB$PRODUCT_STANDARD View changes from previous version. (Word count: 328)
	Apr 28 2008, 11:28 AM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 324)
	Apr 28 2008, 11:28 AM EDT	olapdba	edit	8 words added 1 word deleted
Change: exec :usn := 'DM';break on objdepselect owner\|\|'.'\|\|name\|\|' ('\|\|decode(type, 'MATERIALIZED VIEW', 'MVIEW', 'DIMENSION', 'DIM', 'EVALUATION CONTXT', 'EVALCTXT', 'PACKAGE BODY', 'PKGBDY', type)\|\|')' objdep, referenced_name\|\|' ('\|\|decode(referenced_type, 'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT','NO-EXIST', 'PACKAGE BODY','PKGBDY', referenced_type)\|\|')' refrfrom dba_dependencies where owner='DM'owner=:usn order by objdep; Object Name (Type).......................Object Reference (Type)---------------------------------------- View changes from previous version. (Word count: 324)
	Jan 10 2008, 10:46 AM EST	olapdba	edit	1 word added
Change: DM.SALES_CUBE_JOINED (VIEW)..............CUBE_TABLE (SYNONYM).........................................TIME (CUBE.DIMENSION).........................................PRODUCT (CUBE.DIMENSION).........................................CUSTOMER_REGIONAL_VIEW (VIEW).........................................CUSTOMER (CUBE.DIMENSION).........................................TIME_CALENDAR_VIEW (VIEW).........................................CHANNEL (CUBE.DIMENSION).........................................SALES_CUBE_VIEW (VIEW).........................................OLAPIMPL_T (TYPE.BODY).........................................SALES_CUBE (CUBE).........................................PRODUCT_STANDARD_VIEW (VIEW).........................................CHANNEL_SALES_CHANNEL_VIEW (VIEW)DM.SALES_CUBE_VIEW (VIEW)................SALES_CUBE (CUBE).........................................OLAPIMPL_T (TYPE.BODY).........................................CUBE_TABLE (SYNONYM)... View changes from previous version. (Word count: 317)
	Jan 10 2008, 10:45 AM EST	olapdba	edit	1 word added 1 word deleted
Change: ..........................................OLAPIMPL_T (TYPE.BODY).........................................PRODUCT (CUBE.DIMENSION).........................................CUBE_TABLE (SYNONYM)DM.SALES_CUBE (CUBE).....................AW$DM (TABLE)DM.SALES_CUBE_JOINED (VIEW)..............CUBE_TABLE (SYNONYM).........................................TIME (CUBE.DIMENSION).........................................PRODUCT (CUBE.DIMENSION).........................................CUSTOMER_REGIONAL_VIEW (VIEW).........................................CUSTOMER (CUBE.DIMENSION).........................................TIME_CALENDAR_VIEW (VIEW).........................................CHANNEL (CUBE.DIMENSION).........................................SALES_CUBE_VIEW (VIEW).........................................OLAPIMPL_T (TYPE.BODY).........................................SALES_CUBE (CUBE).........................................PRODUCT_STANDARD_VIEW (VIEW) View changes from previous version. (Word count: 317)
	Jan 10 2008, 10:44 AM EST	olapdba	edit	313 words added
Change: NOTE: I am looking at the schema 'DM' please edit for your schema. set pages500 lines110 col objdep format a40 hea "Object Name (Type)"col refr format a35 hea "Object Reference (Type)" break on objdep select owner\|\|'.'\|\|name\|\|' ('\|\|decode(type, 'MATERIALIZED VIEW', 'MVIEW', 'DIMENSION', 'DIM', 'EVALUATION CONTXT', 'EVALCTXT', View changes from previous version. (Word count: 317)
	Jan 10 2008, 10:33 AM EST	olapdba	create	No content added or deleted.
Change: Created by olapdba Jan 10 2008, 10:33 AM 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