RE: Trailing nullcols and external tables
- From: "Shreeni" <shreeni@xxxxxxxxxxxxx>
- To: <chris_stephens@xxxxxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Sep 2006 16:00:19 -0500
This is my syntax and works like a charm...
CONNECT <mailto:SYSTEM@SHREENI _DEV> SYSTEM@SHREENI _DEV;
CREATE OR REPLACE DIRECTORY DAT_DIR AS '/export/home/oracle/expbackups/';
GRANT ALL ON DIRECTORY DAT_DIR TO CUSTOMER;
DISCONNECT;
CONNECT <mailto:CUSTOMER@CONTENT_DEV> CUSTOMER@SHREENI _DEV;
CREATE TABLE CUSTOMER_EXT
(
CUSTOMER_NAME VARCHAR2(80),
ADDRESS1 VARCHAR2(120),
CITY VARCHAR2(40),
STATE CHAR(2),
COUNTRY VARCHAR2(40),
ZIP_CODE VARCHAR2(10),
FIRST_NAME VARCHAR2(20),
LAST_NAME VARCHAR2(20),
EMAIL_ADDRESS VARCHAR2(120)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY DAT_DIR
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
BADFILE 'customer.bad'
LOGFILE 'customer.log'
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
( CUSTOMER_NAME,
ADDRESS1,
CITY,
STATE,
COUNTRY,
ZIP_CODE,
FIRST_NAME,
LAST_NAME,
EMAIL_ADDRESS
)
)
LOCATION ('CUSTOMER_EXT.CSV')
)
PARALLEL 4
REJECT LIMIT UNLIMITED;
Other related posts:
