Recover datafile corruption
This Article show how to recover from a block failure. In this case partitioned table will be created and single block will be corrupted. · Create Table CREATE TABLE “TEST_TAB_2” ( “ID” NUMBER(10,0) NOT NULL ENABLE, “DESCRIPTION” VARCHAR2(50 BYTE) NOT NULL ENABLE, “CREATED_DATE” DATE NOT NULL ENABLE ) TABLESPACE “USERS” PARTITION BY RANGE (“CREATED_DATE”) (PARTITION “TEST_TAB_Q1” VALUES LESS THAN (TO_DATE(‘ 2008-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)) SEGMENT CREATION IMMEDIATE TABLESPACE “USERS” , PARTITION “TEST_TAB_Q2” VALUES LESS THAN (TO_DATE(‘ 2008-04-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)) SEGMENT CREATION DEFERRED TABLESPACE “USERS” , PARTITION...