Announcement

Collapse
No announcement yet.

Indexes for OTM tables?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Indexes for OTM tables?

    Is there any documentation that shows indexes for OTM tables? It's not available in Oracle's data dictionary documentation. Thank you for your help

  • #2
    Re: Indexes for OTM tables?

    select * from all_indexes
    where owner = 'GLOGOWNER';

    Comment


    • #3
      Re: Indexes for OTM tables?

      sqlplus glogowner/glogowner

      select OWNER, INDEX_NAME, INDEX_TYPE, TABLE_OWNER, TABLE_NAME
      from all_indexes where OWNER in ('GLOGOWNER','GLOGDBA','REPORTOWNER','ARCHIVE','GL OGDEV','GLOBALREPORTUSER','GLOGLOAD')
      order by OWNER, TABLE_NAME;
      Let's connect on LinkedIn
      Mobile: +91 973 049 6886
      E-mail: [email protected]

      If my post was helpful, then click on the Like button

      Comment

      Working...
      X