Perbaixi Index Rusax
untuk 10g only .... memperbaiki index yang rusak.
Aplikasi enaknya mati
SELECT i.obj#, i.flags, u.name, o.name, o.type#
FROM sys.obj$ o, sys.user$ u, sys.ind$ idx, sys.ind_online$ i
WHERE bitand(i.flags, 512) = 512 AND o.obj#=idx.obj# and
o.owner# = u.user# and idx.obj#=i.obj#;
DECLARE
RetVal BOOLEAN;
OBJECT_ID BINARY_INTEGER;
WAIT_FOR_LOCK BINARY_INTEGER;
BEGIN
OBJECT_ID := 317358; --ini Object ID Hasil dari Kueri 1
WAIT_FOR_LOCK := NULL;
RetVal := SYS.DBMS_REPAIR.ONLINE_INDEX_CLEAN ();
COMMIT;
END;
/
Aplikasi enaknya mati
SELECT i.obj#, i.flags, u.name, o.name, o.type#
FROM sys.obj$ o, sys.user$ u, sys.ind$ idx, sys.ind_online$ i
WHERE bitand(i.flags, 512) = 512 AND o.obj#=idx.obj# and
o.owner# = u.user# and idx.obj#=i.obj#;
DECLARE
RetVal BOOLEAN;
OBJECT_ID BINARY_INTEGER;
WAIT_FOR_LOCK BINARY_INTEGER;
BEGIN
OBJECT_ID := 317358; --ini Object ID Hasil dari Kueri 1
WAIT_FOR_LOCK := NULL;
RetVal := SYS.DBMS_REPAIR.ONLINE_INDEX_CLEAN ();
COMMIT;
END;
/
Labels: Oracle
for this post
Leave a Reply