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!

Schema diff

557718Jan 23 2007 — edited Apr 16 2008
Hi,

I compared 2 schemas with the "Schema diff" tool. In the result i found a lot of very strange results:

ALTER TABLE A
ADD ("ID" NUMBER NOT NULL)
;

ALTER TABLE A
DROP COLUMN "ID"
;

I did not run the resulting SQL-file. The differences should still be in the schemas. If i compare these columns manually, with selecting the data from the dictionary (dba_tab_columns, dba_constraints, dba_cons_columns, etc.) i can't see any differences.

Is this a problem of the tool or where can i find this differences?

Tom

P.S. The tool creates the same output for constraints (Primary Keys, Foreign Keys, Unique).
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2008
Added on Jan 23 2007
36 comments
19,091 views