422: l_start_time date := sysdate;
423: l_total_kpis NUMBER := 0;
424:
425: BEGIN
426: bsc_apps.init_bsc_apps;
427: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
428: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
429: IF BSC_METADATA_OPTIMIZER_PKG.gBSCSchema IS NULL THEN
430: BSC_METADATA_OPTIMIZER_PKG.gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
612: IF pOld = pNew tHEN
613: return;
614: END IF;
615:
616: bsc_apps.init_bsc_apps;
617:
618: BSC_METADATA_OPTIMIZER_PKG.g_log := false;
619: BSC_METADATA_OPTIMIZER_PKG.gUIAPI := true;
620:
660: exception when others then
661: null;
662: end;
663: execute immediate 'create synonym '||pNew||' for '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pNew;
664: --BSC_MO_HELPER_PKG.createCopyTable(pOld, pNew, BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type));
665: --BSC_MO_HELPER_PKG.CreateCopyIndexes (pOld, pNew, BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type));
666: --BSC_MO_HELPER_PKG.dropTable(pOld);
667: pStatus := 'Y';
668:
661: null;
662: end;
663: execute immediate 'create synonym '||pNew||' for '||BSC_METADATA_OPTIMIZER_PKG.gBSCSchema||'.'||pNew;
664: --BSC_MO_HELPER_PKG.createCopyTable(pOld, pNew, BSC_APPS.get_tablespace_name(BSC_APPS.input_table_tbs_type));
665: --BSC_MO_HELPER_PKG.CreateCopyIndexes (pOld, pNew, BSC_APPS.get_tablespace_name(BSC_APPS.input_index_tbs_type));
666: --BSC_MO_HELPER_PKG.dropTable(pOld);
667: pStatus := 'Y';
668:
669: EXCEPTION WHEN OTHERS THEN