Bug/feature: export user objects, missing 'set define off' command and FORCE keyword

[Claus Pedersen]

When exporting user objects, the 'set define off' command is missing from the generated files. This means, that if for instance a comment in a package contains an & (ampersand), the user is prompted for input, when the file is executed. The command is present when exporting user tables, so I assume it was just forgotten.

Also, when exporting views, include the keyword FORCE. This will make sure, that the view will always be generated, even on compilation errors. (CREATE OR REPLACE FORCE VIEW my_view AS ...)

Today, we must run the files two or more times, to make sure that all views are created correctly.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Claus Pedersen]

Thanks, please rank the FORCE keyword with a high priority, because it is quite vital that all exported views are also imported again.

 

[sky_lt]

Yes it is really annonying not to have FORCE in views DDL's - i have to use another tool for exporting views.
PL/SQL Developer Version 9.0.4.1644

 

[Claus Pedersen]

Marco, when is ETA for this type of critical bug fixes?

 

[Marco Kalter]

They have been added for the next patch release.

 

[Claus Pedersen]

Can you reveal the list of planned bug fixes for the next patch? I have some personal favourites I would like to promote ...

 

[Claus Pedersen]

This now works in version 9 and 10 (beta1), thumbs up for the developers :grin:

 

[Maxmix]

Taking the opportunity, may I ask again to include FORCE into the commands, generated during "Compare User Objects" operation?