Re: Backup Stored Procedures

From: RC <rclarence_at_tyc.com>
Date: Wed, 29 Dec 1999 16:30:32 GMT
Message-ID: <s6kdp88o5k2145@corp.supernews.com>

Kenny Leung wrote:
>
> Hi All,
>
> I'm not very experienced in Oracle. What is the quickest way to backup
> all stored procedures in an Oracle 8 server for Solaris 5.7? Any help
> appreciated.
>
> Regards,
> Kenny.

You can use export to backup the user who owns all the stored procedures. You can also use export to backup the entire database. Its probably not a bad idea to keep your stored proc code in a change management system like MS Visual source safe as well.

HTH
RC

--
Posted via CNET Help.com
http://www.help.com/ Received on Wed Dec 29 1999 - 10:30:32 CST