Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup stored procedures
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
-- /Karsten DBA > retired > DBAReceived on Wed Jun 11 2003 - 10:31:38 CDT