Re: Export/backup Stored Database Procedures

From: <Jared.Still_at_radisys.com>
Date: Thu, 12 Feb 2004 14:27:08 -0800
Message-ID: <OF5C17A723.019ADBDB-ON88256E38.007B3A24-88256E38.007B43F3@radisys.com>

The implication here seems to be that there is no code version control and no code repository.
I like to use RCS with a well organized directory layout, and back it all up.

Jared

"Michael Fontana" <mfontana_at_verio.net>
Sent by: oracle-l-bounce_at_freelists.org
02/12/2004 11:40 AM
Please respond to oracle-l

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        Export/backup Stored Database Procedures

What methods do most on this list use to back up stored database procedures?

I am familiar with exporting the SYS user only, and importing to another staging database, and pulling the source code out of there, but I must admit, this involves several steps and is a relative "kludge".

A DBA in our group, with Sybase and SQLServer experience, complains because Oracle does not have a method to single out such objects for backup.

Michael Fontana
Sr. DBA
NTT/Verio

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Feb 12 2004 - 16:27:08 CST