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
|
CREATETABLE TEMP_EXTRACT_FILE_SYLV_BASE
(
ENTITY_MEMBER_NM VARCHAR2(10BYTE),
LOB_MEMBER_NM VARCHAR2(6BYTE),
ACTUAL_SOURCE_CD VARCHAR2(7BYTE)
)
ORGANIZATIONEXTERNAL
(TYPE ORACLE_LOADER
DEFAULTDIRECTORY NUIT_EXPORT_DIR
ACCESSPARAMETERS
( RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY';'
(
ENTITY_MEMBER_NM CHAR,
LOB_MEMBER_NM CHAR,
ACTUAL_SOURCE_CD CHAR
)
)
LOCATION(NUIT_EXPORT_DIR:'extract_file_all_200503_base.txt')
)
REJECTLIMITUNLIMITED
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL;
|
Partager