Discussion :

[gaijinma]

Bonjour à tous,

Je me permets de vous déranger pour avoir un peu d'aide sur un problème que je rencontre lors du chargement d' une table sur SQL*Loader.

Je vous donne une partie du code initialisation de la table :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
DROP TABLE mgu_FI_ISSUER;
CREATE TABLE mgu_FI_ISSUER
(
	RECORD_CHANGE_TS TIMESTAMP(6),
	ISSUER_ID VARCHAR2(12),
	ISSUER_NAME VARCHAR2(150),
	COUNTRY VARCHAR2(6),
	STATE VARCHAR2(20),
	ISSUER_NICKNAME VARCHAR2(180),
	CUSIP VARCHAR2(400),
	RECORD_GRP_CD VARCHAR2(8),
	DJ_TICKER VARCHAR2(15),
	NAIC VARCHAR2(8),
	SECTOR VARCHAR2(180),
	SIC VARCHAR2(50),
	ICB VARCHAR2(20),
	NAICS VARCHAR2(20),
	LT_IDR VARCHAR2(15),
	LT_IDR_ACTION VARCHAR2(40),
	LT_IDR_DATE DATE,
	LT_IDR_TREND VARCHAR2(8),
	LT_RTG VARCHAR2(15),
	LT_RTG_ACTION VARCHAR2(40),
	LT_RTG_DATE DATE,
	LT_RTG_TREND VARCHAR2(8),
	LT_NSR VARCHAR2(20),
	LT_NSR_ACTION VARCHAR2(40),
	LT_NSR_DATE DATE,
	LT_NSR_TREND VARCHAR2(8),
	LT_LC_IDR VARCHAR2(20),
	LT_LC_IDR_ACTION VARCHAR2(40),
	LT_LC_IDR_DATE DATE,

Là vous allez trouver le fichier de contrôle de la table :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
LOAD DATA
INTO TABLE mgu_FI_ISSUER
TRUNCATE
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
TRAILING NULLCOLS
(
RECORD_CHANGE_TS  TIMESTAMP "TO_TIMESTAMP(:RECORD_CHANGE_TS,'DD-Mon-YYYY HH:MM:SS', 'NLS_DATE_LANGUAGE = AMERICAN')",
ISSUER_ID CHAR,
ISSUER_NAME CHAR,
COUNTRY CHAR,
STATE CHAR,
ISSUER_NICKNAME CHAR,
CUSIP CHAR,
RECORD_GRP_CD CHAR,
DJ_TICKER CHAR,
NAIC CHAR,
SECTOR CHAR,
SIC CHAR,
ICB CHAR,
NAICS CHAR,
LT_IDR CHAR,
LT_IDR_ACTION CHAR,
LT_IDR_DATE  DATE "TO_DATE(:LT_IDR_DATE,'DD-Mon-YYYY', 'NLS_DATE_LANGUAGE = AMERICAN')",
LT_IDR_TREND CHAR,
LT_RTG CHAR,
LT_RTG_ACTION CHAR,
LT_RTG_DATE  DATE "TO_DATE(:LT_RTG_DATE,'DD-Mon-YYYY', 'NLS_DATE_LANGUAGE = AMERICAN')",
LT_RTG_TREND CHAR,
LT_NSR CHAR,
LT_NSR_ACTION CHAR,
LT_NSR_DATE  DATE "TO_DATE(:LT_NSR_DATE,'DD-Mon-YYYY', 'NLS_DATE_LANGUAGE = AMERICAN')",
LT_NSR_TREND CHAR,
LT_LC_IDR CHAR,
LT_LC_IDR_ACTION CHAR,
LT_LC_IDR_DATE  DATE "TO_DATE(:LT_LC_IDR_DATE,'DD-Mon-YYYY', 'NLS_DATE_LANGUAGE = AMERICAN')",
LT_LC_IDR_TREND CHAR,
LT_LC_RTG CHAR,
LT_LC_RTG_ACTION CHAR,
LT_LC_RTG_DATE  DATE "TO_DATE(:LT_LC_RTG_DATE,'DD-Mon-YYYY', 'NLS_DATE_LANGUAGE = AMERICAN')",
LT_LC_RTG_TREND CHAR,
ST_IDR CHAR,
ST_IDR_ACTION CHAR,
ST_IDR_DATE  DATE "TO_DATE(:ST_IDR_DATE,'DD-Mon-YYYY', 'NLS_DATE_LANGUAGE = AMERICAN')",
ST_IDR_TREND CHAR,
ST_RTG CHAR,

Et enfin les données qui sont à charger :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

"04-dec-2009 08:35:01","80011325","80011325","loma. (Global Series) plc-Sterling Portfolio","IRL","","","","28","","","0801","","","","NR","","","","AAA","Affirmed","04-jun-2008","","NR","","","","NR","","","","NR","","","","NR","","","","NR","","","","NR","","","","Ni","","","","NR","","","","NR","","","","NR","","","","NR","","","","NR","","","","NR","","","","V5","Affirmed","04-jun-2008",""

Je ne comprends pas où j'ai pu me tromper.

Merci encore de votre aide.
Bien à vous.

[mnitu]

Dans 'DD-Mon-YYYY HH:MM:SS' MM signifie le mois et non pas les minutes.