Re: Backup Stored Procedures

From: bmlam <bmlam_at_online.de>
Date: Sun, 02 Jan 2000 21:19:43 +0100
Message-ID: <386FB2DF.4648361@online.de>

My bet is EXPORT (I think it does export stored procedures besides table data) is the quickest to perform but not the most handy tool if you want to re-import just the source code. Otherwise run the following with SQLPLUS: set heading off feedback off echo off
SPOOL <filename>
select text from user_source order by name, type, line; SPOOL OFF will put one schema's source into a single spool file.

Kenny Leung schrieb:

> 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.
Received on Sun Jan 02 2000 - 14:19:43 CST