Hola: i am trying to load date in my table. I was able to insert 100 rows, : then I tried to insert again other 100 rows and : I receive the message: ora-00972 identifier is too long : I have disable "truncate table" and enable : "disable triggers" with option "load Data" : My DDl is: CREATE TABLE CLIENT : ( : ID NUMBER(9) NOT NULL, : NAM_PREFIX_D VARCHAR2(4 CHAR), : FIRST_NAM_D VARCHAR2(15 CHAR), : FIRST_NAM_SDX_D VARCHAR2(4 CHAR), : MIDDLE_NAM_D VARCHAR2(15 CHAR), : LAST_NAM_D VARCHAR2(20 CHAR), : LAST_NAM_SDX_D VARCHAR2(4 CHAR), : NAM_SUFFIX_D VARCHAR2(6 CHAR), : GENDER_IND_D VARCHAR2(6 CHAR), : BIRTH_DTE_D DATE, : DEATH_DTE_D DATE, : SSN_NUM_D VARCHAR2(9 CHAR), : LANGUAGE_CD_SPOKEN_D VARCHAR2(6 CHAR), : LANGUAGE_CD_WRITTEN_D VARCHAR2(6 CHAR), : TELE_AREA_CD_NUM_D VARCHAR2(3 CHAR), : TELE_EXCHANGE_NUM_D VARCHAR2(3 CHAR), : TELE_LINE_NUM_D VARCHAR2(4 CHAR), : TELE_EXT_NUM_D VARCHAR2(5 CHAR), : SMI_ID NUMBER(9), : RACIAL_ETHNIC_CD_D VARCHAR2(6 CHAR), : CONVERSION_COMPLETE_FLG VARCHAR2(1 CHAR), : LAST_UPDT_UID_NAM VARCHAR2(8 CHAR) NOT NULL, : LAST_UPDT_TS DATE NOT NULL : ) : TABLESPACE HM_CORE_TBL_TB : PCTUSED 0 : PCTFREE 10 : INITRANS 4 : MAXTRANS 255 : STORAGE ( : INITIAL 2056K : MINEXTENTS 1 : MAXEXTENTS 2147483645 : PCTINCREASE 0 : BUFFER_POOL DEFAULT : ) : LOGGING : NOCOMPRESS : NOCACHE : PARALLEL ( DEGREE 2 INSTANCES 3 ) : MONITORING; : COMMENT ON TABLE CLIENT IS 'Parent table for client data. The only real data : held on this table is the Client ID (a.k.a HM ID). The rest of the data is : primarily denormalized from child tables -- as a performance enhancement : mechanism for reports, alerts, etc that require just the latest basic : client data.'; : COMMENT ON COLUMN CLIENT.ID IS 'Client ID. This is the clients HM ID. System : generated unique identifier.'; : COMMENT ON COLUMN CLIENT.NAM_PREFIX_D IS 'Name prefix (e.g., Mr., Mrs., etc). : Denormalized from CLIENT_NAM.NAM_PREFIX.'; : COMMENT ON COLUMN CLIENT.FIRST_NAM_D IS 'First name. Denormalized from : CLIENT_NAM.FIRST_NAM'; : COMMENT ON COLUMN CLIENT.FIRST_NAM_SDX_D IS 'First name soundex. Denormalized : from CLIENT_NAM.FIRST_NAM_SDX.'; : COMMENT ON COLUMN CLIENT.MIDDLE_NAM_D IS 'Middle name. Denormalized from : CLIENT_NAM.MIDDLE_NAM'; : COMMENT ON COLUMN CLIENT.LAST_NAM_D IS 'Last name. Denormalized from : CLIENT_NAM.LAST_NAM'; : COMMENT ON COLUMN CLIENT.LAST_NAM_SDX_D IS 'Last name soundex. Denormalized : from CLIENT_NAM.LAST_NAM_SDX.'; : COMMENT ON COLUMN CLIENT.NAM_SUFFIX_D IS 'Name suffix (e.g., Sr., Jr., etc). : Denormalized from CLIENT_NAM.NAM_SFX_TYP_CD_CODE_K.'; : COMMENT ON COLUMN CLIENT.GENDER_IND_D IS 'Gender. Denormalized from : CLIENT_GENDER.GENDER.'; : COMMENT ON COLUMN CLIENT.BIRTH_DTE_D IS 'Birth date. Denormalized from : CLIENT_BIRTH_DTE.BIRTH_DTE.'; : COMMENT ON COLUMN CLIENT.DEATH_DTE_D IS 'Death date. Denormalized from : CLIENT_DEATH_DTE.DEATH_DTE.'; : COMMENT ON COLUMN CLIENT.SSN_NUM_D IS 'Social Security Number. Denormalized : from CLIENT_SSN.SSN_NUM.'; : COMMENT ON COLUMN CLIENT.LANGUAGE_CD_SPOKEN_D IS 'Spoken language. : Denormalized from CLIENT_LANGUAGE.LANGUAGE_CD_CODE_K.'; : COMMENT ON COLUMN CLIENT.LANGUAGE_CD_WRITTEN_D IS 'Written language. : Denormalized from CLIENT_LANGUAGE.LANGUAGE_CD_CODE_WRITTEN_K.'; : COMMENT ON COLUMN CLIENT.TELE_AREA_CD_NUM_D IS 'Phone area code. Denormalized : from CLIENT_TELEPHONE.AREA_CD_NUM. This column will not be used by HM.'; : COMMENT ON COLUMN CLIENT.TELE_EXCHANGE_NUM_D IS 'Phone exchange. Denormalized : from CLIENT_TELEPHONE.EXCHANGE_NUM. This column will not be used by HM.'; : COMMENT ON COLUMN CLIENT.TELE_LINE_NUM_D IS 'Phone line. Denormalized from : CLIENT_TELEPHONE.LINE_NUM. This column will not be used by HM.'; : COMMENT ON COLUMN CLIENT.TELE_EXT_NUM_D IS 'Phone extension. Denormalized : from CLIENT_TELEPHONE.EXT_NUM. This column will not be used by HM.'; : COMMENT ON COLUMN CLIENT.SMI_ID IS 'Client''s Shared Master Index ID. This is : gotten from the SMI.'; : COMMENT ON COLUMN CLIENT.RACIAL_ETHNIC_CD_D IS 'Race/ethnicity. Denormalized : from CLIENT_ETHNIC_ORIGIN.RACIAL_ETHNIC_CD_CODE_K.'; : COMMENT ON COLUMN CLIENT.CONVERSION_COMPLETE_FLG IS 'Flag indicating if the : client has been completed converted - client data added to HM database and : any additional data added for eligibility determination.'; : COMMENT ON COLUMN CLIENT.LAST_UPDT_UID_NAM IS 'User ID of the user who last : updated the row.'; : COMMENT ON COLUMN CLIENT.LAST_UPDT_TS IS 'Timestamp of when the row was last : updated.'; : CREATE UNIQUE INDEX PK_CLIENT ON CLIENT : (ID) : LOGGING : TABLESPACE USERS : PCTFREE 10 : INITRANS 4 : MAXTRANS 255 : STORAGE ( : INITIAL 40K : MINEXTENTS 1 : MAXEXTENTS 2147483645 : PCTINCREASE 0 : BUFFER_POOL DEFAULT : ) : NOPARALLEL; : ALTER TABLE CLIENT ADD ( : CONSTRAINT PK_CLIENT PRIMARY KEY (ID) : USING INDEX : TABLESPACE USERS : PCTFREE 10 : INITRANS 4 : MAXTRANS 255 : STORAGE ( : INITIAL 40K : MINEXTENTS 1 : MAXEXTENTS 2147483645 : PCTINCREASE 0 : )); : GRANT DELETE, INSERT, SELECT, UPDATE ON CLIENT TO HM_DEV_ROLE; : Some idea about my trouble is?
|