BUG: view sql doesnt recognize local indexes

[sagizvi]

1. When will you fix this bug ?

2. at least map the view sql to dbms_metadata ... or give us an option in preferences to decide on doing so.

 

[Marco Kalter]

This is on the to-do list. I'm not sure what you mean with "map the view sql to dbms_metadata". Can you elaborate?

 

[sagizvi]

Today "show sql" generates a DDL by an internal allroundautomations algorithm. This means that your algorithm should be updated when oracle adds a new feature to an object (for example the local index, or maybe even text index).

I wish "show sql" will be able to generate the DDL with oracles package "dbms_metdata.get_ddl".

or at least , for oracle8&9 - use your algorithm for generating ddl, but for oracle10&11 - use dbms_metdata.

I suggest you add an option in the preferences so the users will be able to choose what will "show sql" do -> use dbms_metdata , or internal plsqldeveloper algorithm.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[coder531]

Encountered this issue today and came to the forums to check if its been reported or workaround exists. Would love to have this in a patch sooner rather then later as our organizations utilizes these types of indexes on several tables. A bit annoying have to manually add these to the ddl generated.