--1.Drop the existing table
DROP TABLE CEN_OCS_FORM_10_D_SERVICE;
--2.Recreate the table with the desired column order
CREATE TABLE "UNIFIED_PORTAL"."CEN_OCS_FORM_10_D_SERVICE" 
   (	
    "C_OCS_FORM_10_D_SERVICE_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"C_OCS_FORM_10_D_TEMP_ID" NUMBER(10,0),
    "C_CLAIM_FORM_TYPE" NUMBER(10,0),
    "C_MEMBER_ID" VARCHAR2(22 BYTE),
    "C_MEMBER_SYS_ID" NUMBER(10,0),
    "C_IS_PRIMARY" VARCHAR2(1),
    "C_DOJ_FPS" DATE,
    "C_DOE_FPS" DATE,
    "C_DOJ_EPF" DATE,
    "C_DOE_EPF" DATE,
    "C_DOJ_EPS" DATE,
    "C_DOE_EPS" DATE,
    "C_NCP_DAYS" NUMBER(15,2),
    "C_BIS_DAYS" NUMBER(15,2),
    "C_REASON_OF_LEAVING_EPS" NUMBER(2,0),
    "C_REASON_OF_LEAVING" NUMBER(2,0),
    "C_STATUS" VARCHAR(200),
    "C_IS_BENEFIT_TAKEN" VARCHAR2(1),
    "C_CREATED_BY" VARCHAR2(50),
    "C_CREATED_DATE" TIMESTAMP(6),
    "C_CREATED_ON" VARCHAR2(20),
    "C_RECORD_STATUS" NUMBER(1,0),
    "C_NCP_PR_SEPT_2014" NUMBER(15,2),
    "C_NCP_PST_AUG_2014" NUMBER(15,2),
    "C_WAGES_ON_15NOV95" NUMBER(15,2),
    "C_WAGES_AS_ON_31_AUG_2014" NUMBER(15,2),
    "C_WAGES_ON_DATE_OF_EXIT" NUMBER(15,2),
    "C_PAST_SERVICE_DD" NUMBER(4,0), 
	"C_PAST_SERVICE_MM" NUMBER(4,0), 
	"C_PAST_SERVICE_YY" NUMBER(4,0), 
	"C_PAST_SERVICE_TOTAL_DAYS" NUMBER(4,0), 
	"C_ACTUAL_SERVICE_DD_PR_SEPT_2014" NUMBER(4,0), 
	"C_ACTUAL_SERVICE_MM_PR_SEPT_2014" NUMBER(4,0), 
	"C_ACTUAL_SERVICE_YY_PR_SEPT_2014" NUMBER(4,0), 
	"C_ACTUAL_SERVICE_DD_PST_AUG_2014" NUMBER(4,0), 
	"C_ACTUAL_SERVICE_MM_PST_AUG_2014" NUMBER(4,0), 
	"C_ACTUAL_SERVICE_YY_PST_AUG_2014" NUMBER(4,0),
	 CONSTRAINT "CEN_OCS_FORM_10_D_SERVICE_PK" PRIMARY KEY ("C_OCS_FORM_10_D_SERVICE_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" ;
  
  
  
--    "C_CEN_OCS_FORM_10_D_MAS_ID" NUMBER(10,0),
--	"C_DOJ_FPS71" DATE, 
--	"C_DOE_FPS71" DATE, 
--	"C_DOJ_EPS95" DATE, 
--	"C_DOE_EPS95" DATE, 
--	"C_DOJ_EPF" DATE, 
--	"C_DOE_EPF" DATE,
--	"C_IS_BENEFIT_TAKEN" VARCHAR2(1 BYTE),