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

Dba_index_name and dba_ind_columns showing different results

Category:DefaultRelease time:2015-10-11Views:130

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=[More]

Can I put more than one user under one Apple ID account. I want to let other family members use imessage on their own Apple device. Or is there another way to get this end result?

Category:DefaultRelease time:2015-10-11Views:130

Can I put more than one user under one Apple ID account. I want to let other family members use imessage on their own Apple device. Or is there another way to get this end result?You can seach the net for solutions like this one http://appletvvpn.com[More]

Refresh of Data in Xcelsius from Web Intelligence Results

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am new to the forum but not to Business Objects/Xcelsius.  I attended the SAP Sapphire Event last May and spent time in the Business Objects lab.  Two Product Managers demonstrated how I would be able to refresh the data in an Xcelsius dashb[More]

When i login to yahoo, my first click results in the spinning wheel. Could i have a virus Or why does it only happen when i login to yahoo?

Category:DefaultRelease time:2015-10-11Views:130

When i login to yahoo, my first click results in the spinning wheel. Could i have a virus? Or why does it only happen when i login to yahoo?Firefox allows to select part of a word. You can select a word with a double click and use Shift + left click[More]

Sales Analysis Report - Items -- blank result

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm testing a setup and running the sales analysis report. It works for the Customer version but I get no results when running on Items. I'm on SBO 2007A SP01 PL07. There are open and closed invoices for inventory items; no credit memos have been[More]

BW Web Report Issue - Result set too large

Category:DefaultRelease time:2015-10-11Views:130

Hi, When I execute a BEx Query on Web I am getting "Result set too large ; data retrieval restricted by configuration (maximum = 500000 cells)". Following to my search in SDN I understood we can remove this restriction either across the BW syste[More]

IR: aggregation result in report footer

Category:DefaultRelease time:2015-10-11Views:130

Hello! This quote from "Beginning Oracle Application Express 4.2" at page 174 (about aggregation in IR): "The results are displayed at the end of the report." There is a simple method to print the results of aggregation to the report f[More]

TS2518 Help, I had aperture open and working on a image and did not have a battery in and bumped the power off. As a result it will not open my master, it is locked. when I try to open that Library  it says There was an error opening the database for the

Category:DefaultRelease time:2015-10-11Views:130

Help, I had aperture open and working on a image and did not have a battery in and bumped the power off. As a result it will not open my master, it is locked. when I try to open that Library  it says There was an error opening the database for the li[More]

How can i display the result of java class in InputText ?

Category:DefaultRelease time:2015-10-11Views:130

Hi all, How can i get the result of java class to InputText Or OutputText ??? also can every one in the forum give me road map for dealing with java in oracle adf because i'm beginner in oracle adf i saw some samples in oracle adf corner but it's dif[More]

How can I use ONE Text search iView to event/affect mutliple Result Sets?

Category:DefaultRelease time:2015-10-11Views:130

hello everyone, i have a special situation in which i have 6 flat tables in my repository which all have a common field called Location ID (which is a lookup flat to the Locations table). i am trying to build a page with a free-form text search iView[More]

ITunes Match Unable To Get Past "Waiting for Apple to deliver your iTunes Match results..."

Category:DefaultRelease time:2015-10-11Views:130

Been trying for days but it just gets to "Waiting for Apple to deliver your iTunes Match results..." and then stops and allows me to press the Start button again to start the match process.  Sometimes I get error -3231. I've called Apple and the[More]

Hot
Hi All I have an enhancement issue. Data flow is as follows. (R/3)ZTABLE-(BW)ODS-IC that means data is coming from r/3 ztable into bw ods and hence the cube. Now the R/3 consultant had enhanced a new field in the ZTABLE. What i have to do is, by repl [More]
Hi all. I am currently using Thunderbird 24.4.0 so I don't know if newer version may have this feature. On the main screen, I select several emails and right-click. There we will get "Forward as attachment" on the list. If we choose that, those [More]
Hi!! I am trying to install Oracle 9i with RH9.0 but I have a problem when I execute ./runInstaller Itializing Java Virtual Machine from /tmp/OraInstall/jre/bin/jre. Please wait... /tmp/OraInstall/jre/bin/../lib/i686/green_threads/libzip.so: symbol e [More]
All my photos are on Photoshop Album V2.0 on an old PC running windows XP. I've moved to Macs - OS X Mavericks and want to try and copy my Album catalogue over. I've downloaded Elements 13 free trial on my Mac and am happy with that.  Adobe help says [More]
Hi , I need help from you guys regarding how to add one form to specific responsibility,having sysadmin responsibility i can able to view that form name but don't have idea how to include the form to that particular responsibility. Much appreciated f [More]
Dear Experts , An RFQ is made for a vendor with the One Time Vendor code where its details are punched . Now after delibration , it is decided 2 procure the material form the OTV . But we want to maintain a new  Vendor Master Record for the  vendor . [More]
Hi All I Created a report in doscoverer plus (OracleBI Discoverer 10g (10.1.2.2)). I have a page item LOCATION and in the drop down box i have four locations LOCATION 1,LOCATION 2,LOCATION 3,LOCATION 4. In discoverer plus the page items are working j [More]
Hi everybody, how can i replace the DetailNavigation with an own WD-iView (on the left side of the portal framework page)? regards, SidHi, I believe this question belongs rather to some kind of portal or portal development forum. Please close this th [More]
In AppStore.app for some reason when I try to update my apps, it asks for the wrong user account than the one that I am logged in with. This makes me unable to update my appsYou would have downloaded those apps with the wrong Apple ID then created a [More]
Im trying to run MP3 rocket pro. I have already made it run once since downloading it. Once i closed mp3 rocket and tryed reopening it. I got the box saying i needed to install flash player 10 or higher. I go to adobe and download it. I open up my do [More]