Re: How do I backup functions and procedures in database?
From: jefftyzzer <jefftyzzer_at_sbcglobal.net>
Date: Wed, 16 Jan 2008 18:02:01 -0800 (PST)
Message-ID: <ffa6714a-b2ec-4feb-94f9-f3c495e1911e@m34g2000hsf.googlegroups.com>
Date: Wed, 16 Jan 2008 18:02:01 -0800 (PST)
Message-ID: <ffa6714a-b2ec-4feb-94f9-f3c495e1911e@m34g2000hsf.googlegroups.com>
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 Received on Wed Jan 16 2008 - 20:02:01 CST