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
Hello Experts: I seem to be having a frequent problem while doing a Delta load from BW (3.5) cube to exactly similar cube in BI 7.0. The load is done daily via a Process Chain. Before doing the Delta load, I also have a step to DELET Index from the c [More]
I'm setting up my new iMac and installed Firefox as my internet browser. If I close all the browser windows, it won't open another window even by clicking on File>New Window or using keyboard shortcuts. I have to close the program entirely and reopen [More]
Hi guys. A very weird thing is happening. I am trying to validate that a non-mandatory STANDARD input field (COST_ASSIGNMENT) does not to be empty. This input field belongs to GENERAL_DATA_VIEW, FITE_VC_GENERAL_DATA WD component. The entry fields at [More]
I have a 5th Gen. Ipod. I have plugged it in and I have clicked RESTORE IPOD. It looks like it is doing the job, then......when it is all done...the Ipod says, "Connect to Computer to Restore" (It is already connected). Then the computer still s [More]
Hi All, I have created a BIWS and have scheduled the Webi report separately for each user (we have tried for only 2 users so far). The BIWS property for the getfromuserinstance is set to "1". When we publish the dashboard on the launchpad it doe [More]
structure of  abap programHi See this sample report and note down the structure REPORT zm_reservation_alert        NO STANDARD PAGE HEADING        MESSAGE-ID zm_msg.        D A T A B A S E  T A B L E S   D E C L A R A T I O N                T Y P E S [More]
i opened firefox and it told me to wait a few moments while it updated. when it finished updating the page said i should download to the latest version, and i did. after the d/l was complete, it said it installed correctly and from that point on, nei [More]
I have a iPod nano 6th generation and until this morning it worked fine with iTunes Today when I plugged it in I get the following message...  iPod is detected but could not be identified properly... I have already 1. reinstalled iTunes 2. Tried othe [More]
Ineed to acces my email on my android tablet. Do I have to download an appIF you have a web browser installed just go to http://webmail.verizon.com/signin/Login.jsp?src=SAM&err=1022. If you need a web browser I would recommend https://play.google.com [More]
I have to include screenshots of  data analysis screens (Excel and SPSS) for some writing I am doing. I have been capturing screenshots and saving them as .png files. My question is: does the quality of the screenshot image depend on the resolution o [More]