Here is the tthe table create statement original so as to avoid ORA-12899: value too large for column "GLISADM"."T_CUSTOMER"."CUS_COMPANY" (actual: 81, maximum: 80)

CREATE TABLE "GLISADM"."T_CUSTOMER"
( "CUS_CUSTOMER_ID" NUMBER(10,0),
"CUS_COMPANY" VARCHAR2(150),
"CUS_CONTACT_NAME" VARCHAR2(150),
"CUS_COUNTRY_CODE" VARCHAR2(4),
"CUS_STATUS" CHAR(1) DEFAULT 'V',
"CUS_TYPE" VARCHAR2(6),
"CUS_ADDR1" VARCHAR2(200),
"CUS_ADDR2" VARCHAR2(200),
"CUS_ADDR3" VARCHAR2(200),
"CUS_ADDR4" VARCHAR2(200),
"CUS_PHONE" VARCHAR2(20),
"CUS_FAX" VARCHAR2(30),
"CUS_EMAIL" VARCHAR2(60),
"CUS_COMPANY_DOMAIN" VARCHAR2(60),
"CUS_HP_CODE" VARCHAR2(10),
"CUS_COMMENTS" VARCHAR2(200),
"CUS_CREATE_DATE" DATE,
"CUS_CREATE_BY" VARCHAR2(10),
"CUS_LASTMODIF_DATE" DATE,
"CUS_LASTMODIF_BY" VARCHAR2(10),
CONSTRAINT "C_CUS_SK_01" UNIQUE ("CUS_COMPANY", "CUS_CONTACT_NAME","CUS_COUNTRY_CODE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 4194304 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "GLIS_INDEX" ENABLE,
CONSTRAINT "C_CUS_PK" PRIMARY KEY ("CUS_CUSTOMER_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 4194304 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "GLIS_INDEX" ENABLE,
CONSTRAINT "C_CUS_FK_01" FOREIGN KEY ("CUS_TYPE")
REFERENCES "GLISADM"."T_PARAMETER" ("PAR_TYPE_KEY") ENABLE,
CONSTRAINT "C_CUS_FK_02" FOREIGN KEY ("CUS_COUNTRY_CODE")
REFERENCES "GLISADM"."T_COUNTRY" ("COU_COUNTRY_CODE") ENABLE,
CONSTRAINT "C_CUS_FK_CB" FOREIGN KEY ("CUS_CREATE_BY")
REFERENCES "GLISADM"."T_USER" ("USE_EMPLOYEE_NUM") ENABLE,
CONSTRAINT "C_CUS_FK_MB" FOREIGN KEY ("CUS_LASTMODIF_BY")
REFERENCES "GLISADM"."T_USER" ("USE_EMPLOYEE_NUM") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 134217728 NEXT 134217728 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "GLIS_DATA"

as it contains some foreign keys i have to remove ,so here is the modified version,iam using this to create table

CREATE TABLE "GLISADM"."T_CUSTOMER"
( "CUS_CUSTOMER_ID" NUMBER(10,0),
"CUS_COMPANY" VARCHAR2(150),
"CUS_CONTACT_NAME" VARCHAR2(150),
"CUS_COUNTRY_CODE" VARCHAR2(4),
"CUS_STATUS" CHAR(1) DEFAULT 'V',
"CUS_TYPE" VARCHAR2(6),
"CUS_ADDR1" VARCHAR2(200),
"CUS_ADDR2" VARCHAR2(200),
"CUS_ADDR3" VARCHAR2(200),
"CUS_ADDR4" VARCHAR2(200),
"CUS_PHONE" VARCHAR2(20),
"CUS_FAX" VARCHAR2(30),
"CUS_EMAIL" VARCHAR2(60),
"CUS_COMPANY_DOMAIN" VARCHAR2(60),
"CUS_HP_CODE" VARCHAR2(10),
"CUS_COMMENTS" VARCHAR2(200),
"CUS_CREATE_DATE" DATE,
"CUS_CREATE_BY" VARCHAR2(10),
"CUS_LASTMODIF_DATE" DATE,
"CUS_LASTMODIF_BY" VARCHAR2(10),
CONSTRAINT "C_CUS_SK_01" UNIQUE ("CUS_COMPANY", "CUS_CONTACT_NAME","CUS_COUNTRY_CODE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 4194304 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "GLIS_INDEX" ENABLE,
CONSTRAINT "C_CUS_PK" PRIMARY KEY ("CUS_CUSTOMER_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 4194304 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "GLIS_INDEX" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 134217728 NEXT 134217728 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "GLIS_DATA"
i am dropping the schema and creating it back with this table(nodata)obiviously.