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
Results from EtreCheck Hardware Information:           MacBook Pro (13-inch, Early 2011)           MacBook Pro - model: MacBookPro8,1           1 2.3 GHz Intel Core i5 CPU: 2 cores           8 GB RAM Video Information:           Intel HD Graphics 300 [More]
I have 3 or 4 Excel files on my PC that I would like to keep for reference on my iPad Mini.  I would have to update the files on a weekly basis.  What's the best solution for this? Thank you.go to the app store on the ipad and in the search area type [More]
Hello, I posted a previous message here regarding a problem starting the Oracle services in my laptop, after installing Developer 6i. Well I now know what happened: When I installed Oracle Enterprise, I specified ORAOi as the ORACLE HOME (in C:\oracl [More]
How do you bring back app store icon ? Some how it dis appearedIf you did not set any restriction, Reset Home Screen Layout. Settings>General>Reset>Reset Home Screen Layout.Read other 4 answers [More]
Hi, I don't know whether I am asking a stupid question or not . But my problem is that in my thousand lines of code i wrote number of System.out.println(".....") statements to describe various situations / state of program which write those stri [More]
For some reason, and all of a sudden, hidden (and locked) layers containing content are showing up in Acrobat conversions. This is a huge pain: I send a pdf version of a graphic to a client, and they can see every layer, even though I have it hidden [More]
I attempted to use migration assistant to migrate a user from one mac to another newer one. After sitting on less than one minute remaining for several hours I forced quit on the migration. Based on the amount of hard drive now used on the new comput [More]
how to change pdf files to word?Hi Reyesnancy, Please visit the links mentioned below and purchase the subscription as per your requirement. http://exportpdf.acrobat.com https://www.acrobat.com/createpdf/en/home.html After you puchase the subscriptio [More]
I designed a website that uses a little bit of JavaScript. It displays fine in IE (9), but not in Firefox. Does anyone know why, and what the fix is? Also, and more importantly, I coded audio and video files with Windows media player's class id. They [More]
The process version in the develop settings is sometimes nil, sometimes '5.0'(2003), and sometimes '5.7'(2010). - Begging the questions: (I haven't checked every one but so far if its read as nil by plugin, they're shown as 2003 in Lightroom UI) 1. W [More]