Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> index-table dependency
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.
Received on Sun Oct 14 2007 - 15:39:16 CDT