Home » SQL & PL/SQL » SQL & PL/SQL » index-table dependency
index-table dependency [message #274149] Sun, 14 October 2007 12:03 Go to next message
Messages: 37
Registered: November 2006
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);
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 #274150 is a reply to message #274149] Sun, 14 October 2007 12:31 Go to previous messageGo to next message
Messages: 25578
Registered: January 2009
Location: SoCal
Senior Member
What does a question about index & table have to do with PL/SQL?

The "dependency" between index & table can be found in DBA|ALL|USER|_INDEXES
Re: index-table dependency [message #274230 is a reply to message #274149] Mon, 15 October 2007 02:50 Go to previous message
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.


%_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

Previous Topic: exact fetch returns more than requested number of rows
Next Topic: convert secconds to day:hour:minute:seconds format
Goto Forum:

Current Time: Tue Aug 22 08:11:01 CDT 2017

Total time taken to generate the page: 0.06195 seconds