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 I keep getting the "JBO-26080: Error while selecting entity for Units" error. Below is the query in my View Object. If I remove the Units(Enitty) from the query it works fine but I need to have that in the query. This error occurs only when I [More]
Safari 5.1.7 on my MacBook Pro OS X  10.7.4 freezes after a few minutes of loading.  Any ideas?Hi .. From your Safari menu bar click Safari > Empty Cache If that didn''t help, back to the menu bar click Safari > Reset Safari. Select the top 5 boxes, [More]
Hi we have the scenario in crm like opportunity management , quotation analysis where in pr00 condition we have to input . pr00 condition is mandatory in all the transactions in crm . for this reason pr00 we maintained as mandatory in the pricing pro [More]
I recently got a new iPod Classic (7th Gen) as an anniversary gift, but I've been having trouble with how it handles Podcasts & Audiobooks - the iPod I used to have was a couple of generations older (I think 5th Gen?).  Basically the two biggest issu [More]
Hi, Iam using solaris 10 SUNW,UltraAX-i2. Iam trying to compile tripwire binaries tw_ASR_1.3.1_SRC. Iam using gcc 3.3.2, later I installed the libiconv package. on reading the documentation from sunfreeware i modified the file mkheaders.conf putting [More]
When I am finished editing an image in Lightroom, what files should I have in my Library?  I start with a RAW file or a tiff scan from film. I label that "A" as the archived file. I make a virtual copy to work on in the Develop module. When I am [More]
Prior to OS4, I had three email accounts. Primary was on my own mail server. When all my emails began to originate out of a gMail account, I deleted all accounts but my own email account from my iPhone. New emails are STILL sent from the gMail accoun [More]
Help pleas I lost my iPod at school and I need it by tommorowNo. There is no way to find it without iCloud AllanRead other 2 answers [More]
I need help....dont know what progra to use to do this..obvisously after aclling apple help they cant help me.. Its horrible...' My original computer was stolen..so I have no way to deauthorize that one.. and I want to use my ipod... it has all my ph [More]
Good morning, We are using Plan driven procurement and bidding with Extended classic scenario (SRM 5.0). Indicator IMG sourcing is "Sourcing via automatic bid invitation for items without a source of supply" Is it possible to transfer several PR [More]