Oracle Database 12.2.0
RHEL 7.4
Hello Team,
I would like to know what modifications should I make on table when loading data into the table
DDL for table:
CREATE TABLE "BIREPORT"."ALL_CBASE"
( "ACB_ID" NUMBER(5,0),
"ACB_DATE" DATE,
"ACB_SERVICE" VARCHAR2(50 BYTE),
"ACB_SUB_SERVICE" VARCHAR2(50 BYTE),
"ACB_PACKAGE" VARCHAR2(50 BYTE),
"ACB_OFFER" VARCHAR2(50 BYTE),
"ACB_SUBS_TYPE" VARCHAR2(50 BYTE),
"ACB_SUBS" NUMBER(12,0),
"ACB_POPULATION" NUMBER(10,0),
"ACB_HOUSEHOLD" NUMBER(10,0),
"ACB_REVENUE" NUMBER(12,0),
PRIMARY KEY ("ACB_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "ALL_CBASE" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "ALL_CBASE" NO INMEMORY ;
COMMENT ON COLUMN "BIREPORT"."ALL_CBASE"."ACB_ID" IS 'Primary Key';
Regards,
Joe