This content has been marked as final. Show 2 replies
user12068228 wrote:And what did you expect if you define the source field and target column as 4000 characters?
I'm trying to import a logfile in a database table which has only one column: txt_line
In this column I'm trying to fill a log entry per record. Each log entry normally has more than 4000 bytes so in the external table it should be a clob.
Below is a working external table which works but cuts every entry after 4000 bytes. How ist it possible to directly load the data in a clob column? All I found are descriptions where I have one clob-file per record.
Any help is appreciated
. . . E t c . . .
CREATE TABLE tst_table ( txt_line CLOB ) ORGANIZATION EXTERNAL (TYPE oracle_loader DEFAULT DIRECTORY tmp_ext_tables ACCESS PARAMETERS ( RECORDS DELIMITED BY ']]' FIELDS (txt_line CHAR(32000)) ) LOCATION ('test5.log') ) REJECT LIMIT 0 ;
Thank you. That works!