I dump the entire database through sql developer

In SQL Developer, from the top menu choose Tools> Data Export

When exporting, I get an error

File C: \ Users \ xxx \ export.sql

I understand that not all data is transferred to the file. How to make a full dump without errors?

  • one
    Judging by an error, the data was transferred all, but sql developer decided not to open the export result in the editor, since the file is too big. - PashaPash ♦

1 answer 1

SQL Developer has a limit on the size of the export file that is unloaded in this way. As a workaround, I can advise you to unload not as insert expressions, but let's say, like csv. Save on syntax.