Hello !
I have a table in which one VARCHAR2 column contains line breaks (CR/LF) in some of the rows.
In SQL Developer I want to export the table and then import it in another schema.
I have tried CSV first, but when I try to import (right click on the table > Import data) the same CSV file I get an error for the rows that contain newlines:
"File contains invalid enclosed character data or delimiter at position 80"
I then tried exporting as INSERT. I could successfully import the sql file, but running it in SQL worksheet took 15 minutes, which is way too long (maybe because it displays a '1 rows inserted' after each row ?) .
I exported then as XML. When I try to open it (in import dialog) it fails with a null message.
I tried also json but I guess it does not support json, since it does not show up in the open file dialog filter list.
I don't imagine doing this for several tables.
So how should I do it ?
Regards
Mihai