Re: Can you export a list of all packages

 Message from: galezhang961 

It is my opinion your work, and web-site, are marvelous.

 Plumbing Duncanville 
 Paterson Plumbing 
 plumber West New York 
 New Britain Plumbing 




_______________________________________

Historical Messages 


Author: Bergenfield Plumbing
Date: Thu Nov 24 02:09:48 PST 2011
It is my opinion your work, and web-site, are marvelous.

 Plumbing Duncanville 
 Paterson Plumbing 
 plumber West New York 
 New Britain Plumbing  OWNER NOT IN ( 'SYS' , 'PUBLIC'

Keep in mind that if you’ve created public synonyms (or other such objects
you want to list), you’ll have to alter your query accordingly.

Roger S.


 

__

Author: RJP
Date: Wed Nov 23 11:57:04 PST 2011




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 = ' '

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  
Sent by: [email protected] 

11/23/2011 02:41 PM

Please respond to
[email protected]


 

To

"[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?



 



__

Author: Loralei
Date: Wed Nov 23 10:56:49 PST 2011




 

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?



 


__
_______________________________________