In the Schema Browser | Index, why can I not see the index scripts generated by the system? (4270586)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

In the Schema Browser | Index, why can I not see the index scripts generated by the system?
Description

User cannot see system index scripts (e.g. SYS_IL0000051387C00045$$) or indexes that have the GENERATED set as "Yes."
Resolution

These indexes are created automatically by Oracle when you create a primary key or a unique constraint but Oracle doesn't name it. The user does not need a script for these indexes. If a script is needed, the user should generate the script off the corresponding constraint.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title