oracle外部表问题

CREATE TABLE car_oet_laod
(
car_id VARCHAR2(500 BYTE),
car_nm VARCHAR2(500 BYTE),
car_num VARCHAR2(500 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY LOGGING
ACCESS PARAMETERS 
( records delimited by newline skip 1
logfile EXT:'CAR.txt.log'
fields terminated by '\t' OPTIONALLY ENCLOSED BY '"'
)
LOCATION (EXT:'CAR.txt')
)
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING;
复制

SQL> CREATE TABLE car_oet_laod
  2  (
  3  car_id VARCHAR2(50 BYTE),
  4  car_nm VARCHAR2(50 BYTE),
  5  car_num VARCHAR2(50 BYTE)
  6  )
  7  ORGANIZATION EXTERNAL
  8  ( TYPE ORACLE_LOADER
  9  DEFAULT DIRECTORY TEMP
 10  ACCESS PARAMETERS
 11  ( records delimited by newline skip 1
 12  logfile TEMP:'CAR.txt.log'
 13  fields terminated by '\t' OPTIONALLY ENCLOSED BY '"'
 14  )
 15  LOCATION (TEMP:'cars.txt')
 16  )
 17  REJECT LIMIT UNLIMITED
 18  NOPARALLEL
 19  NOMONITORING;

Table created.

SQL>
SQL> select * from car_oet_laod;

CAR_ID                                             CAR_NM                                             CAR_NUM
-------------------------------------------------- -------------------------------------------------- ----------------
Column1b                                           Column2b                                           Column3b
Column1c                                           Column2c                                           Column3c
Column1d                                           Column2d                                           Column3d
复制