7.3.4 - best way to 'mass extract' data?

Quote:

Originally posted by tamilselvan
Neither PL/SQL proc nor COPY command will work correctly when long column has more than 32K bytes data, b/c the copy command works as the same way of pl/sql.

Not true. COPY command has no limitation in data size of a long column at all and works totaly different as PL/SQL.

You can set SQL*PLus's parameter LONG to anything up to 2GB. And the setting of LONG parameter is the amount of single LONG value that COPY will deal with - the rest will be truncated. And AFAIK the maximum size of LONG can't be larger than 2GB, so tere is no actual limitation at all with COPY regarding LONGs.