--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" ;