Re: index-table dependency

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 14 Oct 2007 21:15:19 GMT
Message-ID: <HFvQi.21639$Pn2.13565@newsfe16.phx>

romantic973_at_gmail.com wrote in news:1192394356.955266.141750 @q5g2000prf.googlegroups.com:

> hi every body i have read about index-table dependency , i think if i
> create an index like
> create index scott_emp_indx on scott.emp(sal/2);
> or
> create index scott_emp_indx2 on scott.emp(lower(ename));
> those indexes should be dependent on scott.emp table but when i check
> on dba_dependencies,all_dependencies i dont find a dependency,
> my question is how can an index-table has dependency relation then.
> thanks for reading.
>
>

If you actually bothered to read the documentation regarding DBA_DEPENDENCIES you see it does not include table/index relationships.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_ 1041.htm#sthref1209

Answers are/were provided hours ago at

http://www.orafaq.com/forum/t/90930/74940/ Received on Sun Oct 14 2007 - 16:15:19 CDT