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