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
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 #274150 is a reply to message #274149] Sun, 14 October 2007 12:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
What does a question about index & table have to do with PL/SQL?
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1041.htm#sthref1209


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

Previous Topic: Exiting from sqlplus when there is any errors while compiling pl/sql programs
Next Topic: is no_data_found needed for this proc (merged)
Goto Forum:
  


Current Time: Sat Dec 10 18:29:15 CST 2016

Total time taken to generate the page: 0.24740 seconds