--1.Drop the existing table

DROP TABLE CEN_OCS_FORM_10_D_NOMINEE_BANK; 
--2.Recreate the table with the desired column order
CREATE TABLE "UNIFIED_PORTAL"."CEN_OCS_FORM_10_D_NOMINEE_BANK" 
   (	
    "C_OCS_FORM_10_D_NOM_BANK_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"C_OCS_FORM_10_D_TEMP_ID" NUMBER(10,0),
    "C_OCS_FORM_10_D_MAS_ID" NUMBER(10,0),
    "C_MEMBER_SYS_ID" NUMBER(10,0),
    "C_MEMBER_ID" VARCHAR2(22 BYTE),
    "C_NOMIATION_ID" NUMBER(12,0),
    "C_NOMINATION_FAMILY_ID" NUMBER(12,0),
    "C_NOMINEE_NAME" VARCHAR2(25),
    "C_NOMINEE_DOB" DATE,
    "C_NOMINEE_RELATION" VARCHAR2(25),
    "C_NOMINEE_MINOR" VARCHAR2(1),
    "C_GUARDIAN_NAME" VARCHAR2(25),
    "C_GUARDIAN_AADHAAR_NO" VARCHAR2(100),
    "C_DISABILITY" VARCHAR2(1),
    "C_DISABILITY_DATE" DATE,
    "C_DISABILITY_CERT_UPLOAD_PATH" VARCHAR2(100),
    "C_NOMINEE_BANK_ID" NUMBER(12,0),
    "C_NAME_AS_PER_BANK" VARCHAR2(25),
    "C_BANK" VARCHAR2(50),
    "C_BANK_ACCOUNT_NO" VARCHAR2(50),
    "C_IFSC" VARCHAR2(10),
    "C_BRANCH_NAME_ADDRESS" VARCHAR2(100),
    "C_PASSBOOK_CHEQUE_UPLOAD_PATH" VARCHAR2(100),
    "C_ROC_NOMINEE" VARCHAR2(1),
    "C_BANK_VERIFY_FLAG" VARCHAR2(1),
    "C_BANK_VERIFY_PROCESS_ID" VARCHAR2(1),
    "C_BANK_VERIFY_FAIL_REASON_ID" NUMBER(2,0),
    "C_BANK_VERIFY_FAIL_REASON" VARCHAR2(50),
    "C_CREATED_BY" VARCHAR2(50),
    "C_CREATED_DATE" TIMESTAMP(6),
    "C_CREATED_ON" VARCHAR2(20) ,
    "C_RECORD_STATUS" NUMBER(1,0),
	 CONSTRAINT "CEN_OCS_FORM_10_D_NOMINEE_BANK_PK" PRIMARY KEY ("C_OCS_FORM_10_D_NOM_BANK_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "UNIFIED_PORTAL"  ENABLE
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "UNIFIED_PORTAL" ;
  