Re: Fastest way to export stored procedures, triggers & packages to text file

On 5 Sep 2003 08:16:31 -0700, flyingbuick_at_yahoo.com (Joe Yong) wrote:

>Hi all,
>Does anyone have recommendations on the fastest way to export stored
>procedures, triggers & packages to text file? We inherited an old
>8.1.7 box and would like to do some analysis offline.
>
>Thanks.

Hi Joe,

select text
from DBA_SOURCE
order by owner, type,name,line;

Spool it via sql*plus or utl_file to a file.

Same with triggers and DBA_TRIGGERS.

• Kenneth Koenraadt