Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - Oracle (Tools)  »  Generating DDL From Designer In a Set Order...
Page 1 of 1    

Generating DDL From Designer In a Set Order...

Author Message
S R...
Posted: Thu Jun 04, 2009 3:19 am
Guest
Designer Version is 10.1.2.0.2.

Whenever I generate the schema/ddl creation scripts after making minor
changes, I like to compare the new scripts against the last set just to
make sure the changes are as I expect. The trouble is each time I
regenerate, the order of the items is different each time, making
comparisons difficult.

I've tried looking for a setting in the preference sets but there isn't
anything obvious . Anyone know how to tell it to set the order of the
tables during generation?
 
Frank van Bortel...
Posted: Sun Jun 07, 2009 7:25 pm
Guest
S R wrote:
Quote:
Designer Version is 10.1.2.0.2.

Whenever I generate the schema/ddl creation scripts after making minor
changes, I like to compare the new scripts against the last set just to
make sure the changes are as I expect. The trouble is each time I
regenerate, the order of the items is different each time, making
comparisons difficult.

I've tried looking for a setting in the preference sets but there isn't
anything obvious . Anyone know how to tell it to set the order of the
tables during generation?

You always could make Designer do that.
Generate Compare Schema option, or something
like that? It's been years since I last used Designer...

--

Regards,
Frank van Bortel
 
 
Page 1 of 1    
All times are GMT
The time now is Sat Dec 05, 2009 2:12 pm