sqlldr + substr marche pas.

Bonjour à tous.
Voila j'essaie de charger un fichier dans une table et je voudrais ne prendre que les 200 premiers caractères de certaines colonnes je fais donc:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
LOAD DATA INFILE 'F1'
TRUNCATE 
INTO TABLE TBL
WHEN (1)!= '#'
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
C1                               ,
C2                                    ,
C3                                   ,
C4                                   ,
C5  "SUBSTR(:C5,1,200)" ,
C6       "SUBSTR(:C6,1,200)" ,
C7     "SUBSTR(:C7,1,200)" ,
C8                                    ,
C9                                  ,
C10                                  ,
C11                                  
)

Sachant que la table ne contient que des varchar2(200 BYTE)
La version d'Oracle est la 9i.

Je me retrouve avec ce type d'erreur:

Code:

1
2
3
 
Record 1: Rejected - Error on table RPT_DM_LOGS_VIC, column C6.
Field in data file exceeds maximum length

Pour cette ligne là:

Code:

1
2
 
2009_01_02-01_53_10.csv:2009/01/02-21:37:58.26,10068,IDL_SEVERE,ClientError,Cannot add an intersection which has a member that has no writable children at the lowest level in cube.,The add intersection operation failed. Possible reasons are :  1. The intersection is composed of a member which is a hanging branch (having no children at the lowest level) in an aggregatable dimension.  2. The user's security settings for the measure do not allow this operation in the intersection scope. ,,AHASSELL,InMemMolap,dm_alcatel1_contmd,./src/interaloc.cpp81,