320:
321: l_data_set_name := p_data_set_name;
322:
323: -- Delete the statistics on Map tables.
324: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'DELETE');
325: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'DELETE');
326: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
321: l_data_set_name := p_data_set_name;
322:
323: -- Delete the statistics on Map tables.
324: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'DELETE');
325: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'DELETE');
326: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
322:
323: -- Delete the statistics on Map tables.
324: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'DELETE');
325: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'DELETE');
326: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
323: -- Delete the statistics on Map tables.
324: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'DELETE');
325: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'DELETE');
326: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
324: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'DELETE');
325: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'DELETE');
326: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
325: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'DELETE');
326: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
326: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
327: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
328: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'DELETE');
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
336:
329: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
336:
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
330: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
336:
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
331: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'DELETE');
332: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
336:
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
333: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
336:
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
334: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
336:
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
335: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'DELETE');
336:
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
336:
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
337: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
338: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
339: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
340: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
341: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
342: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
343: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'DELETE');
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
351:
344: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
351:
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
345: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
351:
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
346: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'DELETE');
347: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
351:
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
348: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
351:
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
349: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
351:
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
350: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'DELETE');
351:
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
351:
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
352: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
353: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
361: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'DELETE');
354: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
361: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'DELETE');
362: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'DELETE');
355: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
361: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'DELETE');
362: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'DELETE');
363: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'DELETE');
356: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'DELETE');
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
361: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'DELETE');
362: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'DELETE');
363: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'DELETE');
364:
357: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'DELETE');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
361: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'DELETE');
362: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'DELETE');
363: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'DELETE');
364:
365: put_stream(g_log, 'Deleted the statistics on all spatial tables');
358: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'DELETE');
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
361: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'DELETE');
362: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'DELETE');
363: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'DELETE');
364:
365: put_stream(g_log, 'Deleted the statistics on all spatial tables');
366:
359: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'DELETE');
360: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'DELETE');
361: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'DELETE');
362: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'DELETE');
363: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'DELETE');
364:
365: put_stream(g_log, 'Deleted the statistics on all spatial tables');
366:
367: -- Re-compute the statistics on Map tables.
364:
365: put_stream(g_log, 'Deleted the statistics on all spatial tables');
366:
367: -- Re-compute the statistics on Map tables.
368: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'COMPUTE');
369: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'COMPUTE');
370: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
365: put_stream(g_log, 'Deleted the statistics on all spatial tables');
366:
367: -- Re-compute the statistics on Map tables.
368: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'COMPUTE');
369: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'COMPUTE');
370: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
366:
367: -- Re-compute the statistics on Map tables.
368: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'COMPUTE');
369: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'COMPUTE');
370: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
367: -- Re-compute the statistics on Map tables.
368: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'COMPUTE');
369: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'COMPUTE');
370: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
368: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS' ||l_data_set_name, 'COMPUTE');
369: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'COMPUTE');
370: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
369: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES' ||l_data_set_name, 'COMPUTE');
370: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
370: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
371: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
372: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS' ||l_data_set_name, 'COMPUTE');
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
380:
373: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
380:
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
374: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
380:
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
375: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES' ||l_data_set_name, 'COMPUTE');
376: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
380:
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
377: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
380:
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
378: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
380:
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
379: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS' ||l_data_set_name, 'COMPUTE');
380:
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
380:
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
381: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
382: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
383: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
384: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
385: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
386: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
387: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS' ||l_data_set_name, 'COMPUTE');
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
395:
388: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
395:
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
389: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
395:
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
390: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES' ||l_data_set_name, 'COMPUTE');
391: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
395:
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
392: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
395:
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
393: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
395:
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
394: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M' ||l_data_set_name, 'COMPUTE');
395:
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
395:
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
396: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
397: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
405: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'COMPUTE');
398: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
405: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'COMPUTE');
406: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'COMPUTE');
399: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
405: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'COMPUTE');
406: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'COMPUTE');
407: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'COMPUTE');
400: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS' ||l_data_set_name, 'COMPUTE');
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
405: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'COMPUTE');
406: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'COMPUTE');
407: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'COMPUTE');
408:
401: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES' ||l_data_set_name, 'COMPUTE');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
405: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'COMPUTE');
406: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'COMPUTE');
407: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'COMPUTE');
408:
409: put_stream(g_log, 'Re-computed the statistics on spatial tables');
402: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS' ||l_data_set_name, 'COMPUTE');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
405: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'COMPUTE');
406: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'COMPUTE');
407: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'COMPUTE');
408:
409: put_stream(g_log, 'Re-computed the statistics on spatial tables');
410: put_stream(g_output, 'Re-computed the statistics on spatial tables');
403: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS' ||l_data_set_name, 'COMPUTE');
404: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS' ||l_data_set_name, 'COMPUTE');
405: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS' ||l_data_set_name, 'COMPUTE');
406: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES' ||l_data_set_name, 'COMPUTE');
407: DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES' ||l_data_set_name, 'COMPUTE');
408:
409: put_stream(g_log, 'Re-computed the statistics on spatial tables');
410: put_stream(g_output, 'Re-computed the statistics on spatial tables');
411: put_stream(g_log, 'The procedure COMPUTE_STATISTICS has completed successfully');