This discussion is archived
6 Replies Latest reply: Oct 25, 2012 8:47 AM by Gary Graham RSS

Export wizard creates views in alphabetical versus dependency order

tx103108 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points