This content has been marked as final. Show 6 replies
user6596050 wrote:Use Oracle® SQL Developer Data Modeler instead.
I am using the below code to extract all DDL for a schema (11gR2).
Is there any way to control the sorting of objects to guarantee the order returned. ...
The users of the SP I created have requested that upon generation of the DDL for a schema, the order of objects remains consistent.
Given that the Oracle documentation does not state and somewhat implies that it controls the fetch order, I posed the question.
NOTE: We are not looking to switch tools to resolve this.
I created a complete toolkit to generate DDL in Oracle V5.0.17 (yes, many moons ago) in Pro*C (GUI & CL) and I was maintaining it up until 8iR3.
At that point, the Oracle Data Dictionary had become bigger than I had time for, so I never incorporated support for anything that came after 8iR3.
We switched from 8iR3 to 11gR2 in production in November of 2011 and one of the post production tasks is to replace my Pro*C toolkit. In doing this, I wanted to simplify as much as possible the need to know Oracle objects in terms of the Oracle Data Dictionary, thus the code I have.
I started with what you suggested, but saw the simplicity in this and changed direction. I guess you cannot have everything.