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
We are using SRM 4.0 in ECS and recently did a refresh to our Quality system.  After the refresh we went through the normal post refresh activities and assumed that everything was ok.  We started creating test shopping carts and PO for XML vendors an [More]
I need ur help urgently. I'm currently doing a java project in which the program should be able to do file searching. For eg. if I key in a.jpg, it should display C:\pictures\a.jpg (a.jpg is stored in a folder called "pictures") But the problem [More]
System: Z820, Win 7  Ultimate x64 Audio: Creative SoundBlaster Recon3D PCIe, Altec Lansing 5.1 speaker system SW: Master Collection CS6 I've been using Premiere Pro CS6 for a while now, but only for stereo video projects. I recently started working o [More]
Hey guys, OT situation but thought you may be able to help. I have a Mega Menu in a Template and Slider on a Dependent Page. The Mega Menu is going behind the page content. How can I properly order this? RobActually, the master has a table and the pa [More]
I have downloaded and installed Adobe Flash and Adobe Reader for Android,directed from login page on Practice Fusion.  Both Adobe programs now have icons on my desktop.  I cannot get beyond the login page and the "download Adobe" instruction pag [More]
My battery seems to work for about 15 minutes, after being fully charged, then the computer just shuts down! Cycle count is 213, and it says "check battery" instead of reading "normal". What does this mean? Do I need to buy a new batte [More]
HI all, I'm new to JSF and JSC. Below are some question which I hope those who has been working on JSF especially those that use JSC to provide me some advice. 1. Can JSF application developed using JSC be changed or modified using other IDE in the m [More]
FaceTime? Are you able to FaceTime using Apple TV?Welcome to the Apple Community. You can mirror a FaceTime conversation from a mobile device to an Apple TV, if that's what you mean.Read other 2 answers [More]
Hi All,    Could anyone give me the solution for the dump I am getting in program RCNMR000, When ever I m selecting the variant STD_SHORTFALL its giving following dump. Short text     Unable to interpret "c " as a number. Its in the standard pro [More]
Lost ability to resize rectangles with latest Illustrator update. Please correct.The following entry may indicate a failing harddrive, so doing backups and replacing the harddrive may be in order. Disk Information:           TOSHIBA MK7559GSXF disk0 [More]