Re: 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
FROM sys.ALL_OBJECTS

To remove the system, itself, add a WHERE clause along the lines of :
OWNER NOT IN ('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."
---------------------------------------------------------------------