Export Data - INSERT SQL script format (relationnal precedence not respected)

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
SQL4Fun
Posts: 3
Joined: Thu 25 Sep 2014 13:45

Export Data - INSERT SQL script format (relationnal precedence not respected)

Post by SQL4Fun » Thu 25 Sep 2014 13:59

Hi everybody,


My goal is to insert data into multiples tables. (from an instance to other one)

I selected some tables, click on 'Export Data', select some options to have INSERT script, unique file, etc.
I get a file with all INSERT sequences
but
it's not taken into account of precedence regarding PK/FK.

That is to say, an INSERT will add data to a table referencing other one without having inserted data into this latter.

Is it by design or I missed something ?
Or perhaps there is an other Tool ?

Thanks in advance for replying.
Regards.

JL.

alexa

Re: Export Data - INSERT SQL script format (relationnal precedence not respected)

Post by alexa » Thu 25 Sep 2014 14:15

Could you please provide us the following information:

1. Example of the exported file.
2. *.det data export template with your specific export settings. It can be generated by clicking the 'Save Template' button being on the last page of the Data Export wizard before you start export.
3. CREATE definitions of the exported tables.
4. Specify the versions of dbForge, Oracle client (if applicable) and Oracle server.
5. Screenshots would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

Post Reply