Oracle_J_添加索引

DECLARE
   i_exists   NUMBER;
BEGIN
   SELECT COUNT (*)
     INTO i_exists
     FROM all_indexes
    WHERE     TABLE_NAME = 'REPORT_DETAIL_UNAUDIT'
          AND INDEX_NAME = 'IX_REPORT_DETAIL_UNAUDIT_ITEM';

   IF i_exists = 0
   THEN
      EXECUTE IMMEDIATE 'CREATE INDEX IX_REPORT_DETAIL_UNAUDIT_ITEM
       ON REPORT_DETAIL_UNAUDIT (ITEM_ID)
       TABLESPACE LIS_SPACE';
   END IF;
END;

COMMIT;