Sign in or 
Share this
Determine Object Dependencies
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)"
variable usn varchar2(20);
exec :usn := 'DM';
break on objdep
select owner||'.'||name||' ('||decode(type,
'MATERIALIZED VIEW', 'MV', 'DIMENSION', 'DIM',
'EVALUATION CONTXT', 'EVALCTXT', 'PACKAGE BODY', 'PKGBDY',
'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)||')' refr
from 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)
.........................................CB$CUSTOMER_REGIONAL (TABLE)
DM.CB$PRODUCT_STANDARD (MV) .............CB$PRODUCT_STANDARD (TABLE)
.........................................PRODUCTS (TABLE)
DM.CB$SALES_CUBE (MV) ...................CUSTOMERS (TABLE)
.........................................COUNTRIES (TABLE)
.........................................CHANNELS (TABLE)
.........................................CB$SALES_CUBE (TABLE)
.........................................SALES (TABLE)
.........................................PRODUCTS (TABLE)
.........................................TIMES (TABLE)
DM.CB$TIME_CALENDAR (MV).. ..............TIMES (TABLE)
.........................................CB$TIME_CALENDAR (TABLE)
DM.CB$TIME_FISCAL (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.DIM)
DM.CHANNEL_VIEW (VIEW)...................CHANNEL (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
.........................................OLAPIMPL_T (TYPE.BODY)
DM.CUSTOMER (CUBE.DIM) ......... ........AW$DM (TABLE)
DM.CUSTOMERS_DIM (DIM)...................COUNTRIES (TABLE)
.........................................CUSTOMERS (TABLE)
DM.CUSTOMER_REGIONAL_VIEW (VIEW).........CUSTOMER (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
.........................................OLAPIMPL_T (TYPE.BODY)
DM.CUSTOMER_VIEW (VIEW)..................OLAPIMPL_T (TYPE.BODY)
.........................................CUSTOMER (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
DM.FORECAST (CUBE).......................AW$DM (TABLE)
DM.FORECAST_VIEW (VIEW)..................FORECAST (CUBE)
.........................................OLAPIMPL_T (TYPE.BODY)
.........................................CUBE_TABLE (SYNONYM)
DM.PRODUCT (CUBE.DIM) ...... ............AW$DM (TABLE)
DM.PRODUCTS_DIM (DIM)....................PRODUCTS (TABLE)
DM.PRODUCT_STANDARD_VIEW (VIEW)..........OLAPIMPL_T (TYPE.BODY)
.........................................CUBE_TABLE (SYNONYM)
.........................................PRODUCT (CUBE.DIM)
DM.PRODUCT_VIEW (VIEW)...................OLAPIMPL_T (TYPE.BODY)
.........................................PRODUCT (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
DM.SALES_CUBE (CUBE).....................AW$DM (TABLE)
DM.SALES_CUBE_JOINED (VIEW)..............CUBE_TABLE (SYNONYM)
.........................................TIME (CUBE.DIMENSION)
.........................................PRODUCT (CUBE.DIM)
.........................................CUSTOMER_REGIONAL_VIEW (VIEW)
.........................................CUSTOMER (CUBE.DIM)
.........................................TIME_CALENDAR_VIEW (VIEW)
.........................................CHANNEL (CUBE.DIM)
.........................................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)
...
set pages500 lines110
col objdep format a40 hea "Object Name (Type)"
col refr format a35 hea "Object Reference (Type)"
variable usn varchar2(20);
exec :usn := 'DM';
break on objdep
select owner||'.'||name||' ('||decode(type,
'MATERIALIZED VIEW', 'MV', 'DIMENSION', 'DIM',
'EVALUATION CONTXT', 'EVALCTXT', 'PACKAGE BODY', 'PKGBDY',
'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)||')' refr
from 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)
.........................................CB$CUSTOMER_REGIONAL (TABLE)
DM.CB$PRODUCT_STANDARD (MV) .............CB$PRODUCT_STANDARD (TABLE)
.........................................PRODUCTS (TABLE)
DM.CB$SALES_CUBE (MV) ...................CUSTOMERS (TABLE)
.........................................COUNTRIES (TABLE)
.........................................CHANNELS (TABLE)
.........................................CB$SALES_CUBE (TABLE)
.........................................SALES (TABLE)
.........................................PRODUCTS (TABLE)
.........................................TIMES (TABLE)
DM.CB$TIME_CALENDAR (MV).. ..............TIMES (TABLE)
.........................................CB$TIME_CALENDAR (TABLE)
DM.CB$TIME_FISCAL (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.DIM)
DM.CHANNEL_VIEW (VIEW)...................CHANNEL (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
.........................................OLAPIMPL_T (TYPE.BODY)
DM.CUSTOMER (CUBE.DIM) ......... ........AW$DM (TABLE)
DM.CUSTOMERS_DIM (DIM)...................COUNTRIES (TABLE)
.........................................CUSTOMERS (TABLE)
DM.CUSTOMER_REGIONAL_VIEW (VIEW).........CUSTOMER (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
.........................................OLAPIMPL_T (TYPE.BODY)
DM.CUSTOMER_VIEW (VIEW)..................OLAPIMPL_T (TYPE.BODY)
.........................................CUSTOMER (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
DM.FORECAST (CUBE).......................AW$DM (TABLE)
DM.FORECAST_VIEW (VIEW)..................FORECAST (CUBE)
.........................................OLAPIMPL_T (TYPE.BODY)
.........................................CUBE_TABLE (SYNONYM)
DM.PRODUCT (CUBE.DIM) ...... ............AW$DM (TABLE)
DM.PRODUCTS_DIM (DIM)....................PRODUCTS (TABLE)
DM.PRODUCT_STANDARD_VIEW (VIEW)..........OLAPIMPL_T (TYPE.BODY)
.........................................CUBE_TABLE (SYNONYM)
.........................................PRODUCT (CUBE.DIM)
DM.PRODUCT_VIEW (VIEW)...................OLAPIMPL_T (TYPE.BODY)
.........................................PRODUCT (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
DM.SALES_CUBE (CUBE).....................AW$DM (TABLE)
DM.SALES_CUBE_JOINED (VIEW)..............CUBE_TABLE (SYNONYM)
.........................................TIME (CUBE.DIMENSION)
.........................................PRODUCT (CUBE.DIM)
.........................................CUSTOMER_REGIONAL_VIEW (VIEW)
.........................................CUSTOMER (CUBE.DIM)
.........................................TIME_CALENDAR_VIEW (VIEW)
.........................................CHANNEL (CUBE.DIM)
.........................................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)
...
olapdba |
Latest page update: made by olapdba
, Apr 28 2008, 11:36 AM EDT
(about this update
About This Update
Edited by olapdba
view changes - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
