Re: How do I backup functions and procedures in database?

On Jan 16, 6:02 pm, jefftyzzer <jefftyz..._at_sbcglobal.net> wrote:
> On Jan 16, 5:15 pm, Sasha <alexk..._at_gmail.com> wrote:
>
> > I've wrote some function and procedures(create function etc.) on PL/
> > SQL
> > How can I back up/save them in case I lose my DB? Is there any tool
> > for that?
>
> > Thanks
>
> Since UDFs and SPs are database objects, they're stored in the data
> dictionary and backed up along with the rest of the database. In
> addition to this, I'd recommend version-controlling your UDFs and SPs
> separately (as you would any code).
>
> --Jeff

Thanks for your help.
How do version control UDFs and SPs? Without manually coping them into cvs or similar version control programs? Thanks Received on Wed Jan 16 2008 - 20:07:19 CST