|
Apr 28 2008, 11:36 AM EDT
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
create |
No content added or deleted. |
|
Change: Created by Jan 10 2008, 10:33 AM EST for: no reason given
|