DBA Data[Home] [Help]

OLAPSYS.OLAPFACTVIEW dependencies on MVIEW$_ADV_PARTITION

Line 1487: -- INSERT INTO SYSTEM.MVIEW$_ADV_PARTITION(runid#,rank#,summary_owner,query_text) VALUES

1483: -- INSERT INTO SYSTEM.MVIEW$_ADV_OUTPUT(RUNID#,OUTPUT_TYPE,RANK#,SUMMARY_OWNER,
1484: -- QUERY_TEXT,STORAGE_IN_BYTES,BENEFIT_TO_COST_RATIO) VALUES
1485: -- (runid,0,i,eOwnerName,bufString,num_bytes,0);
1486:
1487: -- INSERT INTO SYSTEM.MVIEW$_ADV_PARTITION(runid#,rank#,summary_owner,query_text) VALUES
1488: -- (runId,i,eOwnerName,indexString);
1489: dupmvFlag:= TRUE;
1490:
1491: indexString:= '';

Line 3210: INSERT INTO SYSTEM.MVIEW$_ADV_PARTITION(runid#,rank#,summary_owner,query_text) VALUES

3206: INSERT INTO SYSTEM.MVIEW$_ADV_OUTPUT(RUNID#,OUTPUT_TYPE,RANK#,SUMMARY_OWNER,
3207: QUERY_TEXT,STORAGE_IN_BYTES,BENEFIT_TO_COST_RATIO) VALUES
3208: (runid,0,i,eOwnerName,bufString,num_bytes,0);
3209:
3210: INSERT INTO SYSTEM.MVIEW$_ADV_PARTITION(runid#,rank#,summary_owner,query_text) VALUES
3211: (runId,i,eOwnerName,indexString);
3212: dupmvFlag:= TRUE;
3213:
3214: indexString:= '';