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.