I think there is a bug in "Compare user objects" tool. Steps:
1. create simple table in two databases, for example:
2. in one database drop column "SECOND"
3. use "Compare user objects" on table TESTDIF
4. you'll get such script:
there should be:
of course.
Kuba Kr
1. create simple table in two databases, for example:
Code:
create table TESTDIF
(
FIRST VARCHAR2(20),
SECOND VARCHAR2(20),
THIRD VARCHAR2(20)
)
3. use "Compare user objects" on table TESTDIF
4. you'll get such script:
Code:
(...)
-- Add/modify columns
alter table TESTDIF rename column SECOND to THIRD;
Code:
alter table TESTDIF drop column SECOND;
Kuba Kr