How can I set a Index to be or not Generate?

[former_member326375]

Hello Team,

I am working with a Physical Data Model Oracle 11g. In Tables and FK, we have a property "Generate", that can set to generate those objects in DDL Scripts, is it also possible to do it on Indexes?

Image that... I have 3 indexes on the table but in DDL I just want to generate one, how can I do it?

Best Regards

[former_member200945]

Sorry. This tool has problem to upload my answer.

You can set Generate to be true or false.

Then write script to loop Index collection. For each index, if its Generate value is true, keep it, false, delete it.