alter table .... move tablespace ....;atau alter table .... move; (pada tablespace yg sama)
-- best regards database specialist http://www.dbs247.com On Tue, Apr 28, 2009 at 2:32 PM, Andes Febrian <[email protected]> wrote: > Dear gurus, > > mohon pencerahannya, di alert log database saya muncul error : > Corrupt block relative dba: 0x00c10f3d (file 3, block 69437) > Fractured block found during buffer read > Data in bad block: > type: 6 format: 2 rdba: 0x00c10f3d > last change scn: 0x0000.04defeb0 seq: 0x1 flg: 0x06 > spare1: 0x0 spare2: 0x0 spare3: 0x0 > consistency value in tail: 0xf9ea0601 > check value in block header: 0xb2ad > computed block checksum: 0x655 > Reread of rdba: 0x00c10f3d (file 3, block 69437) found same corrupted data > Tue Apr 28 13:45:47 2009 > Corrupt Block Found > TSN = 2, TSNAME = SYSAUX > RFN = 3, BLK = 69437, RDBA = 12652349 > OBJN = 49871, OBJD = 49871, OBJECT = MGMT_METRICS_RAW_PK, SUBOBJECT > = > SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment > > saya coba rebuild, tapi ternyata object ini adalah IOT objek, > SQL> ALTER INDEX MGMT_METRICS_RAW_PK REBUILD; > ALTER INDEX MGMT_METRICS_RAW_PK REBUILD > * > ERROR at line 1: > ORA-28650: Primary index on an IOT cannot be rebuilt > > so bagaimana cara saya untuk mengatasi corrupted block / index ini ? apakah > dengan re-create IOT ini ? bila memang iya, bagaimana cara nya ? > > Many Thanks, > Andes > > [Non-text portions of this message have been removed]
