1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| create table REFPAMUSER.E_PERSONNE
(
ID VARCHAR2(7 CHAR),
NOM VARCHAR2(64 CHAR),
PRENOM VARCHAR2(64 CHAR),
EMAIL VARCHAR2(128 CHAR),
ADRESSE VARCHAR2(200 CHAR)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY DATA_DIR
ACCESS PARAMETERS
(
records delimited by newline
SKIP 1
badfile BAD_DIR:'file1.bad'
logfile LOG_DIR:'file2.log'
fields terminated by ';'
missing field values are null
)
LOCATION ("DATA_DIR":'fichier.csv')
)
REJECT LIMIT UNLIMITED ; |
Partager