Dba_index_name and dba_ind_columns showing different results
Hi All, I am confused why it is showing different results: [email protected]#>select index_name from dba_indexes where table_name='CRBTPROV_FINAL'; INDEX_NAME CRBTPROV_INDX1 [email protected]#>select index_name from dba_IND_COLUMNS where table_name=
I am confused why it is showing different results:
[email protected]#>select index_name from dba_indexes where table_name='CRBTPROV_FINAL';
[email protected]#>select index_name from dba_IND_COLUMNS where table_name='CRBTPROV_FINAL';
When trying to drop index MSISDN_IDX it gives error:
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
But when trying to check where all the index is used using v$access:
select * from v$access where object='MSISDN_IDX';
no rows selected
select type, count(*) from v$access group by type;CURSOR
It seems that index is not taken into account by v$access ?
- 1 Creating a Report that Does Not Require a Target
- 2 No icons in NetworK Connections
- 3 Iphoto 11 is frozen on finishing import. Stop import does not work. How do I fix this?
- 4 I purchased an audiobook on my iphone and it has disappeared. How do I get it back on phone?
- 5 Issue with insatlling ODSEE 220.127.116.11.0 to manual path in Solaris 10
- 6 Alternative unit of Measure for variant material
- 7 Why should i use only 16 points in the sixteen-point garbage matte ?
- 8 Very slow start up and rainbow wheel
- 9 Stupid weird tomcat problem...
- 10 MOV files are not able to be synced into iPhone.
- Trying to connect my macbook to an Epson LQ-570e
- Skillbuilders Modal plugin onclick attribute gets removed
- Can no longer get a connection on iPhone with BT B...
- I had to buy a new Mac Book Pro. When I tried to install Adobe Flash Player, I couldn't get into it with any of my passwords. Can I reset my password and if so, how do I do that? Thanks
- Vendor bill discounting
- Video is backwards in iChat and Photobooth
- I can't set the phone number in imessage
- Rename a set of files in Power Shell
- Lockbox Overpayments and tolerance
- Iphoto macbook: how can find edited photos in macbook from iphone6?