Hello,
I want rebuild the subpartition of local indexes. I want make this dinamics, and I build this code SQL.
When run give me error "ORA-14189: no se puede especificar este atributo físico para una subpartición de índice" ,
any idea?
declare
lanzar varchar2(2000);
Iowner varchar(100);
Iname varchar2(100);
IsubP varchar2(100);
CURSOR INDICESU IS
select *
from dba_ind_subpartitions
where STATUS = 'UNUSABLE' and PARTITION_NAME = 'P4';
indicesA INDICESU%ROWTYPE;
BEGIN
OPEN INDICESU;
LOOP
FETCH INDICESU INTO indicesA;
EXIT WHEN INDICESU%NOTFOUND;
Iowner := indicesA.index_owner;
Iname := indicesA.index_name;
IsubP := indicesA.SUBPARTITION_NAME;
lanzar := RTRIM('ALTER INDEX ' || Iowner || '.' || Iname || ' REBUILD SUBPARTITION ' || IsubP || ';');
DBMS_OUTPUT.put_line ('LANZAR: '|| lanzar);
EXECUTE IMMEDIATE lanzar;
END LOOP;
CLOSE INDICESU;
END;
informe de error -
ORA-14189: no se puede especificar este atributo físico para una subpartición de índice
ORA-06512: en línea 24
14189. 00000 - "this physical attribute may not be specified for an index subpartition"
*Cause: unexpected option was encountered while parsing physical
attributes of an index subpartition; TABLESPACE is the only valid
option
*Action: remove invalid option(s)
Thanks.