Re: Backup Stored Procedures

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 29 Dec 1999 07:28:48 -0500
Message-ID: <ehvj6skb28j2guqd5kbq2ili9np0r8ohl4@4ax.com>

A copy of this was sent to Kenny Leung <kenny_at_optus.net.au> (if that email address didn't require changing) On Wed, 29 Dec 1999 11:36:39 GMT, you 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.

backup the database is one method. procedures are stored in the system tablespace. back it up and you have backed them up.

exp ... rows=N .... is another method. it'll get more then procedures (it extracts the entire structure of the database -- tables, indices, triggers, procedures, etc, etc, etc).

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Dec 29 1999 - 06:28:48 CST