Issues with Comparing User Objects

[CTzen]

v 6.0.1

1) No 'drop table' statements generated if 'Target Session' has more tables then current.

2) If there is a column that needs to be dropped and it has contraint or/and index, PL/SQL Dev will generate following code

--------------------------------
--  Changed table loop_share  --
--------------------------------
-- Drop columns
alter table LOOP_SHARE drop column REASON_ID;
-- Drop primary, unique and foreign key constraints
alter table LOOP_SHARE
  drop constraint FK$LOOP_SHARE$REASONS;
-- Drop indexes
drop index IFK$LOOP_SHARE$REASON_ID;

as you understand second and third statments will fail.

 

[Marco Kalter]

1. Objects in the target session will indeed not be dropped. This option is on the list of enhancement requests.

2. We'll try to fix this.

 

[CTzen]

Thank you, Marco!

Any ETA on 6.0.2 ?-)

 

[Marco Kalter]

We are going for next monday.