SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External table log and bad files

user637544Jun 2 2009 — edited Jun 3 2009

Hi, i have defined the following access parameters for my external table and set REJECT LIMIT to 0:

ACCESS PARAMETERS
(
RECORDS DELIMITED by NEWLINE
BADFILE BAD_DIR:'CARDS.bad'
LOGFILE LOG_DIR:'CARDS.log'
NODISCARDFILE
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
READSIZE 1048576
LRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS

I want to know everytime i query the external table, my log file and bad file will be overwritten or appended? i want them to be overwritten.

This post has been answered by William Robertson on Jun 3 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2009

Added on Jun 2 2009

4 comments

2,005 views