DBA Data[Home] [Help]

APPS.BSC_MV_ADAPTER dependencies on USER_INDEXES

Line 610: select count(1) from user_indexes where index_name=p_index_name

606: end;
607:
608: function index_already_exists(p_index_name varchar2, p_mv_name varchar2, p_mv_owner varchar2) return boolean is
609: cursor cIndexExists is
610: select count(1) from user_indexes where index_name=p_index_name
611: and table_name = p_mv_name and table_owner=p_mv_owner;
612: l_index_exists number;
613: begin
614: open cIndexExists;