After dumping out several thousand records, I get: >ERROR: >ORA-01489: result of string concatenation is too long
without getting exhaustively exhaustive about the thing, anyone seen the error? thanks, ep
http://www.cybcon.com/~jkstill/util/dump/dump.html Dump Tables To A Flat File Dump Oracle Tables To ASCII/Comma Delimited File dump.sql is a utility to dump a single table to a comma and double quote delimited file. In addition, SQL*LOADER control and parameter files will be generated as well. dump.sql will remove all double quotes from the data to avoid confusing SQL*LOADER. If you don't like this behavior, you may easily modify dump.sql to use a different delimiter, or skip using the quotes altogether. The use of the quotes however, makes it possible for commas to appear in the data without confusing SQL*LOADER. dump.sql in ASCII ( http://www.cybcon.com/~jkstill/util/zips/dump.sql )