993:
994: --This cursor is used to check if the mv exists already
995: CURSOR Check_MV_Exists(p_mv_name VARCHAR2) IS
996: SELECT MVIEW_NAME,COMPILE_STATE 997: FROM USER_MVIEWS 998: WHERE MVIEW_NAME = p_mv_name;
999:
1000: --This is used for the cursor Check_MV_Exists
1001: l_mv_name VARCHAR2(200);