Hi guys
I have a question for you about the export of a database with oracle SQL developer.
Let me explain the problem: I had to create my database application from one PC to another, I then performed full export (tables, views and data) in a single file export.sql. When I started the script on the destination PC, I noticed that many mistakes have been raised. By analyzing the code of the file export.sql, I noticed that SQL developer, listed in a disorderly objects to be exported, in particular, has placed first scripts for table creation, then those for the data, then constraints and PK then the constraints of FK, creating problems with the referential integrity constraints.
As a solution to previous errors, I had to run an export file sql representatives each one divided by the creation of the single table, the associated PK, FK and data associated with it. I then performed manually every single script, following an order from the constraints of addiction related to FK. In this way, I rebuilt the DB without errors on the destination PC, but it's an operation was costly in terms of time.
I ask you: is there an option in SQL developer tool to export, that makes it possible to create a script, in which the tables are created, always with their PK FK and data, in the order dictated by dependencies in order to prevent them from being violated referential integrity constraints?
Sorry for my english.
See ya!