In oracle an identifier used as a name for a table, column, index name etc. can have max 30 chars. Is there a way to run a command and display all the entities that have names with more than 30chars.
For instance, I use the generate index for foreign keys options and sometimes, unless the index name is specified, the names that are generated by default might have more than 30chars. Is there way to find these?