Got it Larry!
>
Who is the owner of the table in question?proddta
>
Try using All_Indexes. This is a view that has entries for all indexes that the current user has access to, not just the ones he owns.I tried with:
SQLexec (nJDEHandle, "select * from all_indexes where trim (upper(table_name)) = 'F7611B'", "CurOracle")
and it returned a cursor full of info (below is the display struct of CurOracle), but where do I find the names of the fields that make the index?
Fernando
Field Field Name Type Width Dec Index Collate Nulls
1 OWNER Character 30 No
2 INDEX_NAME Character 30 No
3 INDEX_TYPE Character 27 Yes
4 TABLE_OWNER Character 30 No
5 TABLE_NAME Character 30 No
6 TABLE_TYPE Character 5 Yes
7 UNIQUENESS Character 9 Yes
8 COMPRESSION Character 8 Yes
9 PREFIX_LENGT.. Numeric 20 Yes
10 TABLESPACE_N.. Character 30 Yes
11 INI_TRANS Numeric 20 Yes
12 MAX_TRANS Numeric 20 Yes
13 INITIAL_EXTE.. Numeric 20 Yes
14 NEXT_EXTENT Numeric 20 Yes
15 MIN_EXTENTS Numeric 20 Yes
16 MAX_EXTENTS Numeric 20 Yes
17 PCT_INCREASE Numeric 20 Yes
18 PCT_THRESHOL.. Numeric 20 Yes
19 INCLUDE_COLU.. Numeric 20 Yes
20 FREELISTS Numeric 20 Yes
21 FREELIST_GRO.. Numeric 20 Yes
22 PCT_FREE Numeric 20 Yes
23 LOGGING Character 3 Yes
24 BLEVEL Numeric 20 Yes
25 LEAF_BLOCKS Numeric 20 Yes
26 DISTINCT_KEY.. Numeric 20 Yes
27 AVG_LEAF_BLO.. Numeric 20 Yes
28 AVG_DATA_BLO.. Numeric 20 Yes
29 CLUSTERING_F.. Numeric 20 Yes
30 STATUS Character 8 Yes
31 NUM_ROWS Numeric 20 Yes
32 SAMPLE_SIZE Numeric 20 Yes
33 LAST_ANALYZE.. DateTime 8 Yes
34 DEGREE Character 40 Yes
35 INSTANCES Character 40 Yes
36 PARTITIONED Character 3 Yes
37 TEMPORARY Character 1 Yes
38 GENERATED Character 1 Yes
39 SECONDARY Character 1 Yes
40 BUFFER_POOL Character 7 Yes
41 USER_STATS Character 3 Yes
42 DURATION Character 15 Yes
43 PCT_DIRECT_A.. Numeric 20 Yes
44 ITYP_OWNER Character 30 Yes
45 ITYP_NAME Character 30 Yes
46 PARAMETERS Memo 4 Yes
47 GLOBAL_STATS Character 3 Yes
48 DOMIDX_STATU.. Character 12 Yes
49 DOMIDX_OPSTA.. Character 6 Yes
50 FUNCIDX_STAT.. Character 8 Yes
