SQLLDR/Spooling

Miscellaneous issues when upload/downloading from Oracle.

SPOOLING:
When downloading/Spooling, large fields (Clobs/Memo) were being truncated. Had to SQL>Show all. Linesize,long,longchunksize were defaulting to 80-increased these.

SQLLDR:
sqlldr scott/tiger@LAWSON2 log=log.txt control=loader.ctl

[loader.ctl]
load data
infile ‘c:\merged.dat’
into table seebeyond.RAD_MESSAGES_LDR
fields terminated by “abcZ123″ optionally enclosed by “”
(MESSAGES CHAR(100000))

*To create One table from another: CREATE TABLE ZZZ AS SELECT * FROM AAA

*Set commands (UNION,etc) cannot be used in Clob/Memo fields[amazonify]::omakase::300:250[/amazonify]


Leave a Comment

(required)

(required)

Formatting Your Comment

The following XHTML tags are available for use:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

URLs are automatically converted to hyperlinks.