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.OLAPFACTVIEW dependencies on MVIEW$_ADV_INDEX

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

245: mvdimList mvtype_t:= mvtype_t();
246:
247:
248: BEGIN
249: -- CREATE TABLE SYSTEM.MVIEW$_ADV_INDEX (RUNID# NUMBER NOT NULL,
250: -- RANK# NUMBER NOT NULL,
251: -- SUMMARY_OWNER VARCHAR2(32),
252: -- INDEX_TEXT LONG);
253: numOfMV:= 1;

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

1559: -- bufString:= bufString || 'TABLESPACE TS_INDEX_01 LOCAL COMPUTE STATISTICS';
1560:
1561: -- bufString:= bufString || 'PARALLEL NOLOGGING; ';
1562: -- IF dupmvFlag= TRUE THEN
1563: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
1564: -- SUMMARY_OWNER) VALUES
1565: -- (runid,i,mvnum,0,bufString,eLevelColName,eOwnerName);
1566: -- END IF;
1567: bufString:= '';

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

1608: -- bufString:= bufString || ' ON ' || eMVName || i || '(' || eLevelColName || ') ';
1609: -- bufString:= bufString || 'TABLESPACE TS_INDEX_01 LOCAL COMPUTE STATISTICS';
1610: -- bufString:= bufString || 'PARALLEL NOLOGGING; ';
1611: -- IF dupmvFlag= TRUE THEN
1612: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
1613: -- SUMMARY_OWNER) VALUES
1614: -- (runid,i,mvnum,0,bufString,eLevelColName,eOwnerName);
1615: -- END IF;
1616: bufString:= '';

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

1618: END LOOP;
1619: END IF;
1620: END LOOP;
1621:
1622: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,SUMMARY_OWNER,
1623: -- INDEX_TEXT) VALUES
1624: -- (runid,i,eOwnerName,bufString);
1625:
1626: o:= 0;

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

2003: mvdimList mvtype_t:= mvtype_t();
2004:
2005:
2006: BEGIN
2007: -- CREATE TABLE SYSTEM.MVIEW$_ADV_INDEX (RUNID# NUMBER NOT NULL,
2008: -- RANK# NUMBER NOT NULL,
2009: -- SUMMARY_OWNER VARCHAR2(32),
2010: -- INDEX_TEXT LONG);
2011: numOfMV:= 1;

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

3282: -- END IF;
3283: -- UTL_FILE.PUT_LINE(filehandle,'PARALLEL PCTFREE 0');
3284: -- UTL_FILE.PUT_LINE(filehandle,'NOLOGGING;');
3285: -- UTL_FILE.NEW_LINE(filehandle,2);
3286: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3287: SUMMARY_OWNER) VALUES
3288: (runid,i,mvnum,0,bufString,eLevelColName,eOwnerName);
3289: END IF;
3290: mvnum:= mvnum + 1;

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

3292: -- bufString:= bufString || ' ON ' || eMVName || i || '(' || eLevelColName || ') ';
3293: -- bufString:= bufString || 'TABLESPACE TS_INDEX_01 LOCAL COMPUTE STATISTICS';
3294: -- bufString:= bufString || 'PARALLEL NOLOGGING; ';
3295: -- IF dupmvFlag= TRUE THEN
3296: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3297: -- SUMMARY_OWNER) VALUES
3298: -- (runid,i,mvnum,0,bufString,eLevelColName,eOwnerName);
3299: -- END IF;
3300: bufString:= '';

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

3343: -- END IF;
3344: -- UTL_FILE.PUT_LINE(filehandle,'PARALLEL PCTFREE 0');
3345: -- UTL_FILE.PUT_LINE(filehandle,'NOLOGGING;');
3346: -- UTL_FILE.NEW_LINE(filehandle,2);
3347: INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3348: SUMMARY_OWNER) VALUES
3349: (runid,i,mvnum,0,bufString,eLevelColName,eOwnerName);
3350:
3351: END IF;

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

3353: -- bufString:= bufString || 'TABLESPACE TS_INDEX_01 LOCAL COMPUTE STATISTICS';
3354: -- bufString:= bufString || 'PARALLEL NOLOGGING; ';
3355: -- IF dupmvFlag= TRUE THEN
3356:
3357: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3358: -- SUMMARY_OWNER) VALUES
3359: -- (runid,i + 100,mvnum,0,bufString,eLevelColName,eOwnerName);
3360: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3361: -- SUMMARY_OWNER) VALUES

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

3356:
3357: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3358: -- SUMMARY_OWNER) VALUES
3359: -- (runid,i + 100,mvnum,0,bufString,eLevelColName,eOwnerName);
3360: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,MVINDEX#,INDEX_TYPE,INDEX_NAME,COLUMN_NAME,
3361: -- SUMMARY_OWNER) VALUES
3362: -- (runid,i,mvnum,0,bufString,eLevelColName,eOwnerName);
3363: -- END IF;
3364: bufString:= '';

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

3366: END LOOP;
3367: END IF;
3368: END LOOP;
3369:
3370: -- INSERT INTO SYSTEM.MVIEW$_ADV_INDEX(RUNID#,RANK#,SUMMARY_OWNER,
3371: -- INDEX_TEXT) VALUES
3372: -- (runid,i,eOwnerName,bufString);
3373:
3374: o:= 0;