eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

OLAPSYS.OLAPDIMVIEW dependencies on MVIEW$_ADV_INDEX

Line 267: -- CREATE TABLE SYSTEM.MVIEW$_ADV_INDEX (RUNID# NUMBER NOT NULL,

263: mvdimList mvtype_t:= mvtype_t();
264:
265:
266: BEGIN
267: -- CREATE TABLE SYSTEM.MVIEW$_ADV_INDEX (RUNID# NUMBER NOT NULL,
268: -- RANK# NUMBER NOT NULL,
269: -- SUMMARY_OWNER VARCHAR2(32),
270: -- INDEX_TEXT LONG);
271: cwm2_olap_metadata_refresh.mr_refresh;

Line 1328: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

1324: -- bufString:= bufString || ' ON ' || eMVName || i || '(' || eLevelColName || ') ';
1325: -- bufString:= bufString || 'TABLESPACE TS_INDEX_01 LOCAL COMPUTE STATISTICS';
1326: -- bufString:= bufString || 'PARALLEL NOLOGGING; ';
1327: -- IF dupdimmvFlag= TRUE THEN
1328: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
1329: -- SUMMARY_OWNER) VALUES
1330: -- (runid,i + 100,mvnum,0,bufString,eLevelColName,eOwnerName);
1331: -- END IF;
1332: bufString:= '';

Line 1385: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

1381: -- bufString:= bufString || ' ON ' || eMVName || i || '(' || eLevelColName || ') ';
1382: -- bufString:= bufString || 'TABLESPACE TS_INDEX_01 LOCAL COMPUTE STATISTICS';
1383: -- bufString:= bufString || 'PARALLEL NOLOGGING; ';
1384: -- IF dupdimmvFlag= TRUE THEN
1385: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
1386: -- SUMMARY_OWNER) VALUES
1387: -- (runid,i + 100,mvnum,0,bufString,eLevelColName,eOwnerName);
1388: -- END IF;
1389: bufString:= '';

Line 1673: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,SUMMARY_OWNER,

1669: END IF;
1670: END LOOP;
1671:
1672:
1673: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,SUMMARY_OWNER,
1674: -- INDEX_TEXT) VALUES
1675: -- (runid,i+ 100,eOwnerName,bufString);
1676: UTL_FILE.FCLOSE(filehandle);
1677: commit;

Line 1965: -- CREATE TABLE SYSTEM.MVIEW$_ADV_INDEX (RUNID# NUMBER NOT NULL,

1961: mvdimList mvtype_t:= mvtype_t();
1962:
1963:
1964: BEGIN
1965: -- CREATE TABLE SYSTEM.MVIEW$_ADV_INDEX (RUNID# NUMBER NOT NULL,
1966: -- RANK# NUMBER NOT NULL,
1967: -- SUMMARY_OWNER VARCHAR2(32),
1968: -- INDEX_TEXT LONG);
1969: cwm2_olap_metadata_refresh.mr_refresh;

Line 3001: -- SELECT nvl(max(rank#), 100) INTO rankNum FROM SYSTEM.MVIEW$_ADV_INDEX

2997: -- UTL_FILE.PUTF(filehandle,'ALTER TABLE %s MINIMIZE RECORDS_PER_BLOCK ; ',eMVName);
2998: -- UTL_FILE.NEW_LINE(filehandle,2);
2999:
3000:
3001: -- SELECT nvl(max(rank#), 100) INTO rankNum FROM SYSTEM.MVIEW$_ADV_INDEX
3002: -- WHERE RUNID# = runid;
3003:
3004: -- rankNum:= rankNum + 1;
3005: mvnum:= 0;

Line 3060: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

3056: || counter;
3057:
3058: IF createMV = TRUE THEN
3059: mvnum:= mvnum + 1;
3060: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3061: SUMMARY_OWNER) VALUES
3062: (runid,rankNum,mvnum,0,bufString,eLevelColName,eOwnerName);
3063: END IF;
3064: tpcount:= i;

Line 3116: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

3112: || SUBSTR(dbms_assert.enquote_name(mvdimList(j).hierName),0,2)
3113: || 'BI_'
3114: || counter;
3115:
3116: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3117: SUMMARY_OWNER) VALUES
3118: (runid,rankNum,mvnum,0,bufString,eLevelColName,eOwnerName);
3119: END IF;
3120: tpcount:= i;

Line 3129: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

3125: -- bufString:= bufString || ' ON ' || eMVName || i || '(' || eLevelColName || ') ';
3126: -- bufString:= bufString || 'TABLESPACE TS_INDEX_01 LOCAL COMPUTE STATISTICS';
3127: -- bufString:= bufString || 'PARALLEL NOLOGGING; ';
3128: -- IF dupdimmvFlag= TRUE THEN
3129: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3130: -- SUMMARY_OWNER) VALUES
3131: -- (runid,i + 100,mvnum,0,bufString,eLevelColName,eOwnerName);
3132: -- END IF;
3133:

Line 3170: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

3166:
3167:
3168: IF createMV = TRUE THEN
3169: mvnum:= mvnum + 1;
3170: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3171: SUMMARY_OWNER) VALUES
3172: (runid, rankNum,mvnum,0,bufString,'gid',eOwnerName);
3173: END IF;
3174: bufString:= '';

Line 3327: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

3323:
3324: eLevelColName:= '';
3325: IF createMV = TRUE THEN
3326: mvnum:= mvnum + 1;
3327: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3328: SUMMARY_OWNER,INDEX_CONTENT) VALUES
3329: (runid,rankNum,mvnum,1,bufString,eLevelColName,eOwnerName,indexString);
3330: END IF;
3331: bufString:= ' ';

Line 3391: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,

3387: eLevelColName:= '';
3388: IF createMV = TRUE THEN
3389:
3390: mvnum:= mvnum + 1;
3391: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3392: SUMMARY_OWNER,INDEX_CONTENT) VALUES
3393: (runid,rankNum,mvnum,1,bufString,eLevelColName,eOwnerName,indexString);
3394: END IF;
3395: bufString:= ' ';

Line 3408: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,SUMMARY_OWNER,

3404: -- UTL_FILE.PUT_LINE(filehandle,' degree=>dbms_stats.default_degree, estimate_percent=>dbms_stats.auto_sample_size, method_opt=>''for all hidden columns size 254'') ;');
3405: -- UTL_FILE.NEW_LINE(filehandle,1);
3406:
3407: END LOOP;
3408: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,SUMMARY_OWNER,
3409: -- INDEX_TEXT) VALUES
3410: -- (runid,i+ 100,eOwnerName,bufString);
3411: -- UTL_FILE.FCLOSE(filehandle);
3412: commit;