Sitemap

Amicuk Programming Answers

Dba_index_name and dba_ind_columns showing different results

2015-10-11   Views:0

Advertisement

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=

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='CRBTPROV_FINAL';
INDEX_NAME
CRBTPROV_INDX1
MSISDN_IDX
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
Regards,
Kirti

The replay answer
Advertisement
If I run the following query on a 9.2.0.6 database, no index is listed:
select type, count(*) from v$access group by type;CURSOR
FUNCTION
NON-EXISTENT
PACKAGE
SEQUENCE
SYNONYM
TABLE
TRIGGER
VIEW
It seems that index is not taken into account by v$access ?

Go to See the other 8 answers

Hot
For years, I've used the DIVX Converter/Codec to output video files from Final Cut Pro 7.0.3 via the Export/Use Quicktime Conversion/Divx as a .divx file. But today, after I upgraded my OS from 10.6 to 10.7 and installed the latest version of DIVX Pr [More]
I am aware that it is not at all supported by Adobe, but has anyone been successfully using Photoshop Elements 4 on Leopard and Intel macs of any sort? thank youI had PE4 installed and it was painfully slow and laggy that's why I tried pixelmator and [More]
Hi gurus, What's the difference between segment filtering and reduced message type? It seems they have the same functionality: Reduce the segment while idoc is generated. Thanks in advance.Hi, BD53 is for IDoc Reduction. this allows you to create a r [More]
Ok i'm having trouble with my iPod and album artwork. I googled the problem and some guy was having the same thing happen to him. The idiots replying though didnt understand and started telling him how to put artwork on it. I know how to do that, its [More]
Large product page not displaying correctly on responsive webpage. Not really sure what to adjust or correct. http://iamartde.businesscatalyst.com/apparel-1/i-am-art-sweatshirt-whiteHi, I think it may be <div class="html5gallery-viral-0"> [More]
Hi everyone, first post here for me. I've been currently working on a project in AE CS4. Over the last few days, I have been able to run test renders in h.264 formats. Tonight I've finished my project and am now wanting to render out the final produc [More]
I have set the all the default font in all types to "Times New Roman" as requested by my supervisor (Although I dislike the font =.=) It works correctly for generated field, new text objects or drop a new database field. But whenever I type text [More]
Hello, I am experiencing periodic crashes in an application while using Solaris 2.8 and JVM 1.3.0. The application is invoking multi-threaded java code from C++ and the conflict causing the crashes seems to be in how the threads are being handled. Is [More]
Hi guys, need help with respect to L_TO_CREATE_DN function module. My scenerio is that LT03 tansaction is failing to create TO for the entered HU(pallet number). It is randomly picking pallet available for delivery note and preparing a TO. L_TO_CREAT [More]
I just updated to iTunes 11.4 and received this pop-up:  The system extension AppleUSBEthernetHost.kext was installed improperly and cannot be used.  What does this mean, what problems will this cause, and how do I resolve?Hi JodyGia, If you are havi [More]