Wanted - good SQL*Loader example for large text fields
From: Creative Business Advisers <health_at_mtolympus.ari.net>
Date: 1996/12/14
Message-ID: <58tiu8$2e3_at_ari.ari.net>#1/1
Date: 1996/12/14
Message-ID: <58tiu8$2e3_at_ari.ari.net>#1/1
[Quoted] Anyone have a control file that shows a good example of using large varchar2 fields when loading data from an ascii file into Oracle tables?
Are there any limits (i.e. for Unix on Suns) on the size of a record you can load using SQL*Loader? For example, if you have several large varchar2 fields, say, 2000 bytes each, can SQL*Loader handle this? If need be, we might use PL/SQL or C to write the loader program, but SQL*Loader seems to work fine for smaller size records.
Thanks for any advice.
- Mike