Re: All dependencies whatsoever of a table: how to find them ?
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