Re: Finding the definition of a view

Daniel Lieuwen <lieuwen> wrote:
>Assuming one has DBA priveleges, how does one find the definition of a
>view? No one remembers the exact definition off hand, and we need it back.
>
>Also, where can one find a complete list of system table (e.g. TABS, COLS)?
>Since they don't show up in TABS itself and I can't find even TABS and COLS
>in the indexes of any of the stack of about 10 books that came with the
>distribution, I'm out of ideas as to where to look.
>
>Thanks.
>
>Daniel
>

Daniel,
There are some good reverse engineering scripts for database objects posted on Oracle's OLS, that's RTSS for you new folks. You need to have a valid CSI number and password to login. They were written by Reem Adranly, one of the most competent and knowledgable analysts in the RDBMS support group. Reem used PL/SQL to do hers. I have a few that will do it with out using PL/SQL, mainly because I am so lazy. Hope this helps!

-- 
========================================================================
  Bob Manieri                           email : bmanieri_at_ford.com
  Database Administrator                voice : (610) 584-7085
  Ford Electronics, Lansdale, PA        pager : (609) 342-0314
========================================================================
  Business is war....information is the high ground.  - J.Abrahamson
  ...we can deprive the enemy of the high ground.  - J. Buford
========================================================================