I have an Oracle 11g database with many records and I export all tables and data via SQL Developer. The .sql file produced by the export is more than 2GB and when I always import the script with SQL Developer the process ends after 4 hours. Is there a way to import all tables with data in a better mode?
Another question: in all the tables there are foreign keys, could the insertion of the data generate errors if not done in a certain order? If yes, how do you handle this problem?
I solved my problem using SQL*Loader