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
The page does not load correctly. Things that are supposed to be on the right or left side of the screen appear at the top of the screen in the same column as the posts.Hi Lufte, I'm sorry to hear you are having issues with the rendering of some page [More]
Hi, When I use following code, I get FPRUNX001 system error that : Request start time: Sun Dec 23 23:11:47 CST 2007  (200101)... fp_docparams-langu = 'E'. fp_docparams-country = 'US'. fp_docparams-fillable = 'X'. CALL FUNCTION fm_name   EXPORTING     [More]
I'm having a problem with device capture. I connect my Sony HC-90 via firewire. I can start the capture process in Premier 4 but then all control freezes. Any ideas? Thanks, JeffAre they custom EQ settings in iTunes on the computer? Per: https://disc [More]
hi there! i'm posting this again in order for you to earn duke-bucks. i have a similar problem. i wrote an applet that connects to a video-streamserver an requests a live-stream. the applet sends some udp-packets to the server, which retreives the cl [More]
I have a 3 Mac network. They are connected to a gigabit switch that is attached to a gigabit Airport Extreme. My problem is that I want to have my computers automatically log in to my shared NAS drive when they startup in the mornings (they are on a [More]
I need exeperience comments and guidelines experience for deploying Forms in the WEB. null<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by Pedro Diaz Robles ([email protecte [More]
Hi i have a nokia e72 with two mail boxes. I want to have the mailboxes always connected, but i cant find the option to stays connected with low battery. In my previous phone (nokia e71) i have this option, any help? tanksHi XPTO, Welcome to the Noki [More]
Hello, the customer has LMS 3.1 and he uses RME for the backup of config files and vlan.dat files from netwrok devices. It is working fine, but he has problem with backuping vlan.dat files from the following switches: Cat2960-8TC,-24TC, Cat2960G-24TC [More]
Hi all, I am doing call transaction for IM32,CJ30 and IM52.But iam unable to capture the messages. when we enter a wrong budget values then it throws a error message saying 'Errors found-> see error log'(The same is present in BDCMSGCOLL). But we nee [More]
I've learned two things about kernel extensions from Google searches: 1. Kernel extensions are stored in System/Library/Extensions 2. You can list all Apple extensions with the Terminal command kextstat and all third party extensions with the command [More]