Re: Backup stored procedures

On Wed, 11 Jun 2003, Karsten Farrell wrote:

> hannem_at_tihlde.org said...
> > Hi,
> > is it possible only to backup stored procedures using the exp utilty?
> > eg exp user/password
> > file=file.dat
> > log=log.log
> > owner=owner
> > tables=user_source
> >
> > regards Hanne
> > --
> > Hanne Midttun
> > http://www.tihlde.org/~hannem
> >
> > No! Try not. Do. Or do not. There is no try. - Yoda
> >
> >
>
> You could do a variation on this theme:
>
> spool myproc.bak
> select text
> from user_source
> where name = 'MYPROC'
> order by line;
> spool off

I tought off doing it this way, but I am not familiar with all the settings in sql (set verify off, echo off, linesize and so on) to create a file containing only the source.

Good ide, if I have been better :-)

Hanne

--
Hanne Midttun
http://www.tihlde.org/~hannem

No! Try not. Do. Or do not. There is no try. - Yoda