RE: determine tables in view (9iR2)

  • From: cosmin ioan <cosmini@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 9 Feb 2007 14:16:50 -0800 (PST)

thanks all  !    thanks Tim!
  dba_dependencies and of course, the plan.... ha.... the plan, would do it! 
  learning new stuff every day!  the nice part is that the learning never ends 
so, I'll never get bored ;-)  he he he      

Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx> wrote:
  e.g. this query shows all the tables used by view DBA_SEGMENTS?
  set linesize 100
column obj_level format a16
column obj format a40
column refobj format a40
   lpad (' ', 2 * (level - 1)) || to_char (level, '999') as obj_level,
   owner || '.' || name || ' (' || type || ')' as obj,
   referenced_owner || '.' || referenced_name || ' (' || referenced_type || ')'
      as refobj
 from dba_dependencies
 start with owner = 'SYS' and name = 'DBA_SEGMENTS'
 connect by prior referenced_owner = owner and prior referenced_name = name
    and prior referenced_type = type
    and type in ('TABLE', 'VIEW') ;

  De : oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] De 
la part de cosmin ioan
Envoyé : vendredi, 9. février 2007 12:20
À : oracle-l@xxxxxxxxxxxxx
Objet : re: determine tables in view (9iR2) 

  hi all,
  is there a (relatively) simple query or function to obtain all tables from a 
view, keeping in mind that that view can have many subviews which in turn could 
have many subviews etc etc (recursive func)  
  I don't want to re-invent the wheel nor write some funky long pl/sql, if 
something already exists out there  ;-)
  thx much,

Other related posts: