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.

MDSYS.SDO_ROUTER_PARTITION dependencies on DBMS_ASSERT

Line 92: WHERE username = UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));

88:
89: -- Make sure the Routeserver schema specified actually exists
90: SELECT COUNT(*) INTO row_count
91: FROM all_users
92: WHERE username = UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));
93:
94: if (row_count = 0)
95: then raise_application_error(-20011, '[ERROR] schema does not exist');
96: end if;

Line 137: SYS.DBMS_ASSERT.ENQUOTE_LITERAL(directory_path);

133: end if;
134:
135: -- Create the directory
136: stmt := 'CREATE OR REPLACE DIRECTORY sdo_router_log_dir as '||
137: SYS.DBMS_ASSERT.ENQUOTE_LITERAL(directory_path);
138: EXECUTE IMMEDIATE stmt;
139:
140: directory_path := directory_path || '*';
141:

Line 143: stmt := 'GRANT read, write ON DIRECTORY sdo_router_log_dir TO ' || UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));

139:
140: directory_path := directory_path || '*';
141:
142: -- Grant privileges to the directory to the Router user and MDSYS
143: stmt := 'GRANT read, write ON DIRECTORY sdo_router_log_dir TO ' || UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));
144: EXECUTE IMMEDIATE stmt;
145: dbms_java.grant_permission(
146: UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema)), 'java.io.FilePermission',
147: directory_path, 'read,write');

Line 146: UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema)), 'java.io.FilePermission',

142: -- Grant privileges to the directory to the Router user and MDSYS
143: stmt := 'GRANT read, write ON DIRECTORY sdo_router_log_dir TO ' || UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));
144: EXECUTE IMMEDIATE stmt;
145: dbms_java.grant_permission(
146: UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema)), 'java.io.FilePermission',
147: directory_path, 'read,write');
148:
149: EXECUTE IMMEDIATE 'GRANT read, write ON DIRECTORY sdo_router_log_dir TO MDSYS';
150: dbms_java.grant_permission(

Line 322: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);

318: stmt VARCHAR2(256);
319: BEGIN
320:
321: EXECUTE IMMEDIATE 'truncate table ' ||
322: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);
323:
324: stmt := 'SELECT MIN(P_ID) FROM final_partition';
325: EXECUTE IMMEDIATE stmt into min_pid ;
326:

Line 328: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' (vertex_id,p_id,x,y) ' ||

324: stmt := 'SELECT MIN(P_ID) FROM final_partition';
325: EXECUTE IMMEDIATE stmt into min_pid ;
326:
327: stmt := 'INSERT /*+ APPEND */ into ' ||
328: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' (vertex_id,p_id,x,y) ' ||
329: ' select vertex_id, (p_id-:min_pid+1),x,y from final_partition';
330: EXECUTE IMMEDIATE stmt USING min_pid;
331:
332: COMMIT;

Line 353: SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(tab_name) || ' WHERE m < 0 ';

349: part_m := 0;
350:
351: -- two partitions for partition pid is based on the m sign (<0 or >= 0 )
352: stmt := 'SELECT COUNT(*) FROM ' ||
353: SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(tab_name) || ' WHERE m < 0 ';
354: EXECUTE IMMEDIATE stmt into vno1;
355:
356: vno2 := v_no - vno1;
357:

Line 363: SYS.DBMS_ASSERT.ENQUOTE_NAME(tab_name) ||

359: -- move n vertices from set (m < 0) to set (m>= 0)
360: -- by flipping its sign of m
361: no := (vno1-vno2)/2;
362: stmt := 'SELECT min(m) FROM (SELECT m FROM ' ||
363: SYS.DBMS_ASSERT.ENQUOTE_NAME(tab_name) ||
364: ' WHERE m < 0 ORDER BY m DESC) ' || ' WHERE rownum <= :no ';
365: EXECUTE IMMEDIATE stmt into part_m USING no;
366:
367: INSERT /*+ APPEND */ INTO partition_tmp_3 (vertex_id,p_id,x,y,m)

Line 378: SYS.DBMS_ASSERT.ENQUOTE_NAME(tab_name) ||

374: -- move n vertices from set (m >= 0) to set ( m < 0) by
375: -- updating pid in vertex table
376: no := (vno2-vno1)/2;
377: stmt := 'SELECT max(m) FROM (SELECT m FROM ' ||
378: SYS.DBMS_ASSERT.ENQUOTE_NAME(tab_name) ||
379: ' WHERE m >= 0 ORDER BY m) ' || ' WHERE rownum <= :no ' ;
380: EXECUTE IMMEDIATE stmt into part_m USING no;
381:
382: INSERT /*+ APPEND */ INTO partition_tmp_3 (vertex_id,p_id,x,y,m)

Line 417: partition_tmp_1 := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name);

413: -- terminal condition for bisecting
414: -- if vertex no. smaller than max_v_no ,stops
415:
416: IF (partition_id = 0) THEN
417: partition_tmp_1 := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name);
418: ELSE
419: partition_tmp_1 := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || partition_id;
420: END IF;
421:

Line 419: partition_tmp_1 := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || partition_id;

415:
416: IF (partition_id = 0) THEN
417: partition_tmp_1 := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name);
418: ELSE
419: partition_tmp_1 := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || partition_id;
420: END IF;
421:
422: stmt := 'SELECT COUNT(*) FROM ' || partition_tmp_1;
423: EXECUTE IMMEDIATE stmt into v_no;

Line 433: stmt := 'SELECT AVG(x), AVG(y) from ' || SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(partition_tmp_1);

429: --
430: -- prepare data for eigenvalue/eigenvector calculation
431: --
432:
433: stmt := 'SELECT AVG(x), AVG(y) from ' || SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(partition_tmp_1);
434: EXECUTE IMMEDIATE stmt into x_mean, y_mean;
435:
436: stmt := 'SELECT mdsys.SDO_ROUTER_PARTITION.min_eigenvector(
437: sum(power(x-:1,2)), sum(power(y-:2,2)),

Line 468: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);

464: COMMIT;
465: END IF;
466:
467: IF (partition_id = 0) THEN
468: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);
469: ELSE
470: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || partition_id;
471: EXECUTE IMMEDIATE 'DROP TABLE ' || table_name;
472: END IF;

Line 470: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || partition_id;

466:
467: IF (partition_id = 0) THEN
468: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);
469: ELSE
470: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || partition_id;
471: EXECUTE IMMEDIATE 'DROP TABLE ' || table_name;
472: END IF;
473:
474:

Line 477: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || part_counter;

473:
474:
475: IF (v_no/2 > max_v_no) THEN
476:
477: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || part_counter;
478: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN
479: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
480: END IF;
481:

Line 478: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN

474:
475: IF (v_no/2 > max_v_no) THEN
476:
477: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || part_counter;
478: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN
479: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
480: END IF;
481:
482: stmt := 'CREATE TABLE ' || table_name ||

Line 479: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);

475: IF (v_no/2 > max_v_no) THEN
476:
477: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || part_counter;
478: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN
479: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
480: END IF;
481:
482: stmt := 'CREATE TABLE ' || table_name ||
483: ' STORAGE (maxextents unlimited), NOLOGGING as

Line 487: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || sdo_util.number_to_char(part_counter+1);

483: ' STORAGE (maxextents unlimited), NOLOGGING as
484: SELECT * FROM partition_tmp_3 WHERE p_id=' || part_counter;
485: EXECUTE IMMEDIATE stmt;
486:
487: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || sdo_util.number_to_char(part_counter+1);
488:
489: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN
490: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
491: END IF;

Line 489: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN

485: EXECUTE IMMEDIATE stmt;
486:
487: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || sdo_util.number_to_char(part_counter+1);
488:
489: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN
490: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
491: END IF;
492: stmt := 'CREATE TABLE ' || table_name ||
493: ' STORAGE (maxextents unlimited), NOLOGGING as

Line 490: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);

486:
487: table_name := SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name) || '_' || sdo_util.number_to_char(part_counter+1);
488:
489: IF ( table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'TRUE') THEN
490: execute immediate 'DROP TABLE ' || SYS.DBMS_ASSERT.ENQUOTE_NAME(table_name);
491: END IF;
492: stmt := 'CREATE TABLE ' || table_name ||
493: ' STORAGE (maxextents unlimited), NOLOGGING as
494: SELECT * FROM partition_tmp_3 WHERE p_id=' || sdo_util.number_to_char(part_counter+1);

Line 535: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);

531: RETURN ;
532: END IF;
533:
534: stmt := 'SELECT MIN(p_id), MAX(p_id) FROM ' ||
535: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);
536: EXECUTE IMMEDIATE stmt INTO min_pid, max_pid;
537:
538: stmt := 'SELECT COUNT(*) FROM ' ||
539: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' WHERE p_id = :min_pid';

Line 539: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' WHERE p_id = :min_pid';

535: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);
536: EXECUTE IMMEDIATE stmt INTO min_pid, max_pid;
537:
538: stmt := 'SELECT COUNT(*) FROM ' ||
539: SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' WHERE p_id = :min_pid';
540: EXECUTE IMMEDIATE stmt INTO v_no USING min_pid;
541:
542: p_level := floor(LN(v_no/max_v_no)/LN(2.0));
543:

Line 567: new_partition_proc(SYS.DBMS_ASSERT.NOOP(p_tab_name), max_v_no, pid, make_equal, p_counter);

563: FOR k IN min_pid..max_pid LOOP
564: FOR i IN 0..p_level LOOP
565: p_date := sysdate;
566: FOR j IN 1..power(2,i) LOOP
567: new_partition_proc(SYS.DBMS_ASSERT.NOOP(p_tab_name), max_v_no, pid, make_equal, p_counter);
568: pid := pid +1;
569: END LOOP;
570: log_message('INFO: partitioning '|| p_tab_name ||
571: ' level: ' || i || ' partition id: ' || pid);

Line 579: adjust_final_pid(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name));

575: END LOOP;
576: END LOOP;
577:
578: -- Copy the result back to original table and ajust the pids
579: adjust_final_pid(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name));
580:
581: log_message('INFO: completed partitioning of '|| p_tab_name);
582:
583: EXCEPTION

Line 1152: IF (table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'FALSE') THEN

1148: PROCEDURE gather_table_stats(table_name IN VARCHAR2)
1149: IS
1150: stmt VARCHAR2(256):= 'EXECUTE DBMS_STATS.GATHER_TABLE_STATS(:schema_name, :table_name, NULL, DBMS_STATS.AUTO_SAMPLE_SIZE)';
1151: BEGIN
1152: IF (table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'FALSE') THEN
1153: log_message('ERROR: ' || table_name || ' not found for gather table statistics');
1154: RETURN ;
1155: END IF;
1156:

Line 1377: l_network_name := nls_upper(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(network_name));

1373: BEGIN
1374: full_file_name := open_log_file(log_file_name);
1375:
1376: -- Sanity check the passed in network name
1377: l_network_name := nls_upper(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(network_name));
1378:
1379: -- Build the view names based on the network names
1380: link_view_name := l_network_name || '_LINK$';
1381: node_view_name := l_network_name || '_NODE$';

Line 1471: SYS.DBMS_ASSERT.ENQUOTE_LITERAL('Y') || ' user_data_included

1467: num_non_boundary_edges num_ilinks,
1468: num_outgoing_boundary_edges+num_incoming_boundary_edges num_elinks,
1469: num_incoming_boundary_edges num_inlinks,
1470: num_outgoing_boundary_edges num_outlinks, ' ||
1471: SYS.DBMS_ASSERT.ENQUOTE_LITERAL('Y') || ' user_data_included
1472: from
1473: (select 1 link_level, partition_id partition_id
1474: from PARTITION
1475: where partition_id > 0

Line 1553: l_network_name := nls_upper(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(network_name));

1549: pblob_view_name VARCHAR2(256);
1550: stmt VARCHAR2(512);
1551: BEGIN
1552: full_file_name := open_log_file(log_file_name);
1553: l_network_name := nls_upper(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(network_name));
1554:
1555: -- raise an error if the network doesn't exist
1556: IF (network_exists(l_network_name) = 'FALSE') THEN
1557: log_message('ERROR: network delete failed, ' || l_network_name || ' network not found');

Line 1586: SYS.DBMS_ASSERT.ENQUOTE_NAME(link_view_name);

1582:
1583: -- cleanup views
1584: IF (table_exists(link_view_name) = 'TRUE') THEN
1585: EXECUTE IMMEDIATE 'DROP VIEW ' ||
1586: SYS.DBMS_ASSERT.ENQUOTE_NAME(link_view_name);
1587: END IF;
1588:
1589: IF (table_exists(node_view_name) = 'TRUE') THEN
1590: EXECUTE IMMEDIATE 'DROP VIEW ' ||

Line 1591: SYS.DBMS_ASSERT.ENQUOTE_NAME(node_view_name);

1587: END IF;
1588:
1589: IF (table_exists(node_view_name) = 'TRUE') THEN
1590: EXECUTE IMMEDIATE 'DROP VIEW ' ||
1591: SYS.DBMS_ASSERT.ENQUOTE_NAME(node_view_name);
1592: END IF;
1593:
1594: IF (table_exists(part_view_name) = 'TRUE') THEN
1595: EXECUTE IMMEDIATE 'DROP VIEW ' ||

Line 1596: SYS.DBMS_ASSERT.ENQUOTE_NAME(part_view_name);

1592: END IF;
1593:
1594: IF (table_exists(part_view_name) = 'TRUE') THEN
1595: EXECUTE IMMEDIATE 'DROP VIEW ' ||
1596: SYS.DBMS_ASSERT.ENQUOTE_NAME(part_view_name);
1597: END IF;
1598:
1599: IF (table_exists(pblob_view_name) = 'TRUE') THEN
1600: EXECUTE IMMEDIATE 'DROP VIEW ' ||

Line 1601: SYS.DBMS_ASSERT.ENQUOTE_NAME(pblob_view_name);

1597: END IF;
1598:
1599: IF (table_exists(pblob_view_name) = 'TRUE') THEN
1600: EXECUTE IMMEDIATE 'DROP VIEW ' ||
1601: SYS.DBMS_ASSERT.ENQUOTE_NAME(pblob_view_name);
1602: END IF;
1603:
1604: COMMIT;
1605:

Line 2432: adjust_final_pid(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name));

2428: end loop;
2429: end loop;
2430:
2431: -- copy the result back to original table and ajust the pids
2432: adjust_final_pid(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(p_tab_name));
2433:
2434: log_message('INFO: completed recovery of '|| p_tab_name || ' partitioning');
2435:
2436: EXCEPTION