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

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sat, 6 Sep 2003 20:29:32 +0300
Message-ID: <3f5a197c$1_1@news.estpak.ee>

Hi!

Why not full export with rows=n (and possibly specifying needed schemas) instead?
Utl_file and sqlplus spooling are very slow...

Tanel.

<Kenneth Koenraadt> wrote in message
news:3f58a9ea.2337170_at_news.inet.tele.dk...
> 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
Received on Sat Sep 06 2003 - 12:29:32 CDT