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?
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: toad@yahoogroups.com
11/23/2011 02:41 PM
Please respond to
toad@yahoogroups.com
To
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?
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.
Thank you…( brain fade here evidently!)
And always remember…when life hands you Lemons, ask for tequila and salt and
call me over
Loralei writes:
And always remember....when life hands you Lemons, ask for tequila and salt
and call me over
Now THAT's a disclaimer I can understand. Well done!
Happy Thanksgiving to all the US folk!
Rich -- [TeamT]
Disclaimer: GO PACK GO!
It is my opinion your work, and web-site, are marvelous.
Plumbing Duncanville
Paterson Plumbing
plumber West New York
New Britain Plumbing
It is my opinion your work, and web-site, are marvelous.
..
List of 4 plumbing sites I won’t repeat
It appears the spammers are attempting to be more subtle by offering flattery in
exchange for the unsolicited advertising.
Of course… I could be mistaken. The particular company could just have the
4 sites as an automatic part of the email and they really are a customer of
Quest. In that case, my apologies for misunderstanding the intent of the
message.
Roger S.