Sqlplus SP2-0341 (line overflow during variable substitution)

oracleoracle-sql-developersqlplus

I want to export an Oracle database to a file and i'm using SQLDeveloper on Windows for that (the resulting SQL text file is about 35MB). This results in very long lines.

I hit a snag when importing the file using sqlplus on linux:

SP2-0341: line overflow during variable substitution (>3000 characters at line 1)

This occurs on multiple lines.

I see no options on how to limit the length of the lines when exporting. I've tried to set line size and then export, to no avail. I've also tried to edit the file but the vim tools i used focus on explicit line length and not the semantics of SQL (they'll break strings). Also my regex-fo can only go as far as surrounding the VALUES keyword with newlines, but even then the lines are still much longer than 3000. Also, 35MB is a lot to edit by hand.

I'm limited to those tools and RDBMS but i'm open to suggestions.

Best Answer

SQL*Plus is not a data loading tool. Use the proper tools.

SQL Developer can create CSV files. Instead of SQL*Plus, use SQL*Loader to load the data.

SQL*Plus Limits

enter image description here

Related Question