Peoplesoft Data Mover error:


While working with creating the db manually using psdmtx utility on Linux I kept getting the following error while loading the tables.

SQL Error. Error Position: 464  Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_GPFR_AF_ATTR"."DESCR60" (actual: 62, maximum: 60)
INSERT INTO PS_GPFR_AF_ATTR  (COUNTRY, GPFR_AF_APPL, GPFR_AF_KEY_NODE, GPFR_AF_KEY_ATTR, GPFR_AF_ATTR_NAME, GPFR_AF_ATTR_STAT, GPFR_AF_ATTR_SEQ, DESCR60, GPFR_AF_ATTR_TYPE, GPFR_AF_ATR_LENGTH, GPFR_AF_ATR_DECIML, GPFR_AF_MANDATORY, GPFR_AF_ATR_LBLSRC, GPFR_AF_CODE_ID, GPFR_AF_PROMPT, GPFR_DA_DATTYP, GPFR_AF_PR_LBL_FLD, GPFR_AF_PR_KEY_FLD, GPFR_AF_ATTR_FIELD, GPFR_AF_PS_DON, GPFR_AF_CUST_DON, GPFR_AF_RPT_ONLY, GPFR_AF_OWNER) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23)
Error: Unable to insert row 1337
Error: SQL execute error for GPFR_AF_ATTR
 SQL Spaces: 0  Tables: 4669  Triggers: 0 Indexes: 5431  Views: 0
Ended: Wed May  7 20:27:07 2014
Unsuccessful completion







This error perplexed me.  Then I ran the same utility on Windows.  Thats when I got the following error.

Character Length Semantis (CLS) Feature is not enabled.

The solution is to make the change as follows:

alter system set NLS_LENGTH_SEMANTICS=CHAR scope=both;

and bounce the db.