Hi,
I am working with Oracle 12cr2 (non-PDB) and 19cR3 (PDB) databases.
I am trying to list the LOB indexes fora given user.
Logged as a given user MY_USER, when I run:
- select index_name from user_indexes;
Some of the indexes are LOB-indexes with thism format SYS_IL0000084489C00007$$ and of type=LOB.
- select * from all_indexes where owner = 'MY_USER';
I do not see the LOB-indexes any more.
Does someone know what the reason is?
Kind Regards