extract whole schema’s package hit problem.
i need to extract the whole APPS schema packages spec and body, the problem is, there got nearly thousands of packages..it will make the my toad hung or use up all my pc memory; i can't do it with export becoz the users need it in readable format. do u hv any idea? hope somebody may help, or reply me to 'rain5forest@yahoo.com' tq.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 12, 2007 3:49 PM
UPDATED:
October 15, 2007 4:22 PM
Answer Wiki:
Just a quick though looking at this. Why not have a simple piece of PL/SQL that reads the packages from the DBA_SOURCE Table and dumps it into a file on the file system. That way it can be made to be readable and held in a file. You may need to play with the formatting a little but I have done this for screens looking at stored packages in HTML and managed to get them to show very well and the retrieve is fast.
I know its not pretty, but could get over your initial issue.
I hope it helps a little.
Fatboy
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
