Re: Can you export a list of all packages

Thank you.....( brain fade here evidently!)

 
And always remember....when life hands you Lemons, ask for tequila and salt and call me over


________________________________
 From: Ray Paschke <[email protected]>
To: [email protected] 
Cc: "[email protected]" <[email protected]> 
Sent: Wednesday, November 23, 2011 12:57 PM
Subject: Re: [toad] Can you export a list of all packages
 

  
Why not query the system tables? 

SELECT 
        owner, 
        object_name, 
        object_type, 
        created, 
        last_ddl_time, 
        status 
FROMsys.ALL_OBJECTS 

To remove the system, itself, add a
WHERE clause along the lines of : 
OWNER NOTIN('SYS','PUBLIC','SYSTEM',
. . .) 

For the objects in a specific schema: 
OWNER = '<schema_name>' 

You could spool the SQL from TOAD, itself,
and use that SQL to generate your lists. 

Ray Paschke
System Analyst
Federal Home Loan Bank of Pittsburgh
Desk: 412-288-5548
Cell: 412-260-7026 



Loralei <[email protected]>  
Sent by: [email protected] 
11/23/2011 02:41 PM 
Please respond to
[email protected] 
 To "[email protected]" <[email protected]>  
cc  
Subject [toad] Can you export a list of all
packages 
  
 



 
In an effort to create an inventory and source collection
for all packages, procedures etc within TOAD databases, I am wondering
if there is a way in which I could export a list of all items( pkgs, sprocs
etc) rather than creating a handwritten list?  

 
 


---------------------------------------------------------------------
"The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited.  If you received this in error, please contact the sender and delete the material from any computer."
---------------------------------------------------------------------