Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> dump.sql
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 )
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: PierceED_at_csus.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Apr 04 2002 - 19:03:24 CST