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