SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
error loading data - need help

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
error loading data - need help
Author Message
Astrid



Joined: 03 Nov 2005
Posts: 2

Post error loading data - need help Reply with quote

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?


Fri Nov 04, 2005 5:42 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Re: error loading data - need help Reply with quote

This issue has been addressed in the latest build 5.0.4.116. You can download it here http://www.softtreetech.com/idbtools.htm

: Hola: i am trying to load date in my table. I was able to insert 100 rows,

Tue Nov 08, 2005 1:35 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.