Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Modeler: Generate Delta-Scripts against an existing schema

Gerd VolbergSep 14 2009 — edited Nov 4 2009
Can I generate DDL-Scripts with "ALTER TABLE " - statements?

For example: relational model and database are in synch. That means: Each Table of the db is stored in the data model of the Data Modeler.

Now I need new columns in a table. I define these columns in the data-model and now I need a script with :

ALTER TABLE my_table ADD (new_column DATE);

In Oracle Designer it is more than easy to create such delta-scripts. But I found nothing similiar in the Data Modeler

thanks in advance
Gerd
This post has been answered by Philip Stoyanov-Oracle on Sep 14 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2009
Added on Sep 14 2009
5 comments
2,692 views