index-table dependency [message #274149] |
Sun, 14 October 2007 12:03 |
prince973
Messages: 37 Registered: November 2006
|
Member |
|
|
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 i dont find a dependency,
my question is how can an index-table has dependency relation then.
thanks for reading.
|
|
|
|
Re: index-table dependency [message #274230 is a reply to message #274149] |
Mon, 15 October 2007 02:50 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
So, lets get this straight.
You heard the phrase 'Index-Table Dependency' and you and you found the view DBA_DEPENDENCIES, and without bothering to even look at the documentation you decided that these had to be talking about the same thing.
Right.
%_DEPENDENCIES describes the dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user,
including dependencies on views created without any database links.
Really - don't just make assumptions about how things work. Check it out in the documentation.
{edited for line length}
[Updated on: Mon, 15 October 2007 03:31] Report message to a moderator
|
|
|