6 Replies Latest reply: Oct 25, 2012 10:47 AM by Gary Graham-Oracle RSS

    Export wizard creates views in alphabetical versus dependency order

    tx103108
      Oracle SQL Developer 3.1.07 on Windows 7 SP1 64-bit
      Oracle Database Oracle EE 11gR1 64-bit on OEL 5.4 64-bit
      ====================================

      Export tool (Tools-> Database Export) generates DDL for views in alphabetical order instead of dependency order, hence running generated .sql file fails to create views.
      Tool does seem to generate DDL in correct order for objects in general (i.e., tables before constraints).

      Is there something I am missing in the tool that will ensure the DDL for views is generated in the correct order?

      Thank you.