Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> index-table dependency

index-table dependency

From: <romantic973_at_gmail.com>
Date: Sun, 14 Oct 2007 13:39:16 -0700
Message-ID: <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. Received on Sun Oct 14 2007 - 15:39:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US