ORA-1652 : Oracle

REM
REM Пресоздание индексов
REM

SET echo off feedback off verify off pagesize 0 linesize 150

DEFINE OWNER_MASK = 'SUPERMAG'

PROMPT Create command file ...

SPOOL IdxRepair.txt
select 'ALTER INDEX "'||OWNER||'"."'||INDEX_NAME||'" REBUILD NOLOGGING COMPUTE STATISTICS;'
  from DBA_Indexes
 where OWNER like '&OWNER_MASK'
   and TEMPORARY = 'N'
 order by LEAF_BLOCKS;

SPOOL off
SET echo on feedback on
PROMPT Execute command file ...
SPOOL IdxRepair.log
START IdxRepair.txt
SPOOL off
SET echo off;