Re: All dependencies whatsoever of a table: how to find them ?

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Thu, 09 Mar 2000 17:27:52 GMT
Message-ID: <8a8mug$pu4$1_at_nnrp1.deja.com>



Using my freeware SQLPlusPlus's command LSTDEP you could list dependencies
of any object from withing Oracle SQL*Plus.

regards,
M. Armaghan Saqib

+---------------------------------------------------------------
[Quoted] | 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL
| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/
+---------------------------------------------------------------
| SQLPlusPlus now on http://www.ioug.org/
[Quoted] |   "PL/SQL package that extends SQL*Plus to another dimension.
| Contains a PL/SQL code generator and set of extremely useful | utilites with extensive documentation." IOUG Web Site
+---------------------------------------------------------------

<monsri_at_my-deja.com> wrote in message news:8a5nbg$io9 $1_at_nnrp1.deja.com...
> Hi here,
> I'd like to know if anybody ever wrote a tool that would
> allow to find for a given table ALL its dependencies whatsoever,
> I really mean ANY KIND OF dependencies it may have (not only
> what you'll find in DBA_DEPENDENCIES, but also all occurences
> of records regarding this table in DBA_CONSTRAINTS, DBA_TAB_PRIVS
> for the roles, DBA_SYNONYMS etc etc.) ??
>
> I really need to know EVERYTHING about a table ! I could of course
> do it manually, but er... if someone has already written such
> a script, I guess it would spare me the time to rewrite it !!
>
> Anybody can help me ??
>
> Thanks a lot !
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 09 2000 - 18:27:52 CET

Original text of this message