Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backup stored procedures

Re: Backup stored procedures

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Wed, 11 Jun 2003 15:31:38 GMT
Message-ID: <MPG.1950eb344e79b00d9897c5@news.la.sbcglobal.net>


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 > DBA
Received on Wed Jun 11 2003 - 10:31:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US