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 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
| CREATE TABLE MyTable (
"ASS_ID" VARCHAR2(100),
"ASS_ID_UNIQUE" VARCHAR2(100),
"ASS_IMMA_NUM" VARCHAR2(100),
"ASS_IMMA_SEC" VARCHAR2(100),
"ASS_IMMA_COMP" VARCHAR2(100),
"ASS_IMMA_MANU" VARCHAR2(100),
"ASS_NOM" VARCHAR2(255),
"ASS_PRENOMS" VARCHAR2(255),
"ASS_SURNOM" VARCHAR2(255),
"ASS_DENOMINATION" VARCHAR2(500),
"ASS_SIGLE" VARCHAR2(50),
"ASS_NOM_COMM" VARCHAR2(250),
"ASS_CAPITAL" VARCHAR2(100),
"ASS_NAISSANCE" VARCHAR2(100),
"PAY_ID_NAISS" VARCHAR2(100),
"COM_ID_NAISS" VARCHAR2(150),
"ASS_NAISS_REG_AUTRE" VARCHAR2(50),
"ASS_NAISS_COM_AUTRE" VARCHAR2(50),
"ASS_PERE_NOM" VARCHAR2(50),
"ASS_MERE_NOM" VARCHAR2(50),
"ASS_CONJOINT_NOM" VARCHAR2(255),
"ASS_ADRESSE" VARCHAR2(255),
"ASS_LIEU_NAISS" VARCHAR2(255),
"PAY_ID_ADR" VARCHAR2(100),
"COM_ID_ADR" VARCHAR2(100),
"ASS_ADR_REG_AUTRE" VARCHAR2(500),
"ASS_ADR_COM_AUTRE" VARCHAR2(500),
"ASS_DEBUT" VARCHAR2(100),
"ASS_DUREE" VARCHAR2(30),
"ASS_FIN" VARCHAR2(100),
"ASS_CLOTURE" VARCHAR2(100),
"ASS_VAL_NOMI" VARCHAR2(30),
"ASS_NOMBRE" VARCHAR2(30),
"ASS_OBJET" VARCHAR2(255),
"ASS_INFO_ORIGINE" VARCHAR2(256),
"ASS_ETAB_DENOMINATION" VARCHAR2(250),
"ASS_ETAB_ENSEIGNE" VARCHAR2(50),
"ASS_ETAB_ADRESSE" VARCHAR2(500),
"PAY_ID_ETAB_ADR" VARCHAR2(100),
"COM_ID_ETAB_ADR" VARCHAR2(100),
"ASS_ETAB_ADR_REG_AUTRE" VARCHAR2(50),
"ASS_ETAB_ADR_COM_AUTRE" VARCHAR2(50),
"ASS_ETAB_SIEGE_ADRESSE" VARCHAR2(500),
"PAY_ID_ETAB_SIEGE" VARCHAR2(15),
"COM_ID_ETAB_SIEGE" VARCHAR2(15),
"ASS_ETAB_SIEGE_ADR_REG_AUTRE" VARCHAR2(50),
"ASS_ETAB_SIEGE_ADR_COM_AUTRE" VARCHAR2(50),
"ASS_ETAB_ACTIVITES" VARCHAR2(500),
"ASS_ETAB_DEBUT" VARCHAR2(100),
"ASS_ETAB_ORIGINE" VARCHAR2(500),
"ASS_ETAB_INFO_ORIGINE" VARCHAR2(256),
"ASS_ETAB_DUREE" VARCHAR2(100),
"ASS_ETAB_FIN" VARCHAR2(100),
"ASS_ETAB_CLOTURE" VARCHAR2(100),
"ASS_ETAB_IMMA_DATE" VARCHAR2(100),
"ASS_ETAB_OBS" VARCHAR2(500),
"ASS_ETAB_DPS_NOM" VARCHAR2(50),
"ASS_ETAB_DPS_PRENOMS" VARCHAR2(50),
"ASS_ETAB_DPS_ADRESSE" VARCHAR2(50),
"PAY_ID_ETAB_DPS" VARCHAR2(100),
"COM_ID_ETAB_DPS" VARCHAR2(100),
"ASS_ETAB_DPS_REG_AUTRE" VARCHAR2(50),
"ASS_ETAB_DPS_COM_AUTRE" VARCHAR2(50),
"ASS_ETAB_OBS_FONDS" VARCHAR2(256),
"ASS_SIEGE_ETRANGER" VARCHAR2(100),
"ASS_INCOMPLET" VARCHAR2(100),
"ASS_PIECES_ATTENTE" VARCHAR2(256),
"ASS_DATE_MAX_REGUL" VARCHAR2(100),
"ASS_DEBLOQUE" VARCHAR2(100),
"ASS_RADIE" VARCHAR2(100),
"ASS_VALIDE" VARCHAR2(100),
"TAS_ID" VARCHAR2(100),
"DEV_ID" VARCHAR2(100),
"NAT_ID" VARCHAR2(100),
"DPS_ID" VARCHAR2(100),
"FJU_ID" VARCHAR2(100),
"EXR_ID" VARCHAR2(100),
"SMA_ID" VARCHAR2(100),
"RMA_ID" VARCHAR2(100),
"GRF_ID" VARCHAR2(100),
"ORF_ID" VARCHAR2(100),
"ORI_ID" VARCHAR2(100),
"USER_CRE" VARCHAR2(50),
"DATE_CRE" VARCHAR2(50),
"USER_UPD" VARCHAR2(50),
"DATE_UPD" VARCHAR2(50),
"ASS_SEXE" VARCHAR2(100),
"ASS_NOM_DEC" VARCHAR2(100),
"ASS_PRENOM_DEC" VARCHAR2(100),
"ASS_ADRESSE_DEC" VARCHAR2(50),
"PAY_ID_DEC" VARCHAR2(100),
"COM_ID_DEC" VARCHAR2(100),
"ASS_DEC_COM_AUTRE" VARCHAR2(50),
"ASS_DEC_REG_AUTRE" VARCHAR2(50),
"ASS_ETAB_ETRANGER_ADRESSE" VARCHAR2(500),
"PAY_ID_ETAB_ETRANGER" VARCHAR2(100),
"COM_ID_ETAB_ETRANGER" VARCHAR2(100),
"ASS_ETAB_ETRANGER_REG_AUTRE" VARCHAR2(255),
"ASS_ETAB_ETRANGER_COM_AUTRE" VARCHAR2(255),
"CST_ID" VARCHAR2(50),
"STY_ID" VARCHAR2(50),
"ASS_CIVILITE" VARCHAR2(100),
"ASS_OBSERVATION" VARCHAR2(500),
"ASS_SOURCE_MODIF" VARCHAR2(255)
)
ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER
DEFAULT DIRECTORY mydirectory
ACCESS PARAMETERS ( records delimited by newline
badfile MYDIRECTORY:'MyTable.bad'
logfile MYDIRECTORY:'MyTable.log'
fields terminated by ','
missing field values are null)
LOCATION ('DATA_MyTable.csv.txt'))
PARALLEL REJECT LIMIT UNLIMITED; |
Partager